Home > Archive > Visual Basic Crystal Reports > March 2006 > Why is my numeric data automatically truncated?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why is my numeric data automatically truncated?
|
|
| anasttin@excite.com 2006-03-27, 7:05 pm |
| Hi,
I have a problem with data being truncated.
I start a blank report and insert one field from an oracle sql database
and the field automatically truncates all non-whole numbers so that
value 2.56 becomes 2.00.
If I look at that table in Access or SQL plus, it does have all the
decimal places but for whatever reason, Crystal 9, truncates it.
It doesn't appear to be a formatting option as I've investigated that
but I am now at a loss.
Any help would be much appreciated.
Thanks
| |
|
| On the report, right click the field...click on FORMAT FIELD...select the
NUMBER tab and set how the number is displayed.
TomB.
"anasttin@excite.com" wrote:
> Hi,
>
> I have a problem with data being truncated.
>
> I start a blank report and insert one field from an oracle sql database
> and the field automatically truncates all non-whole numbers so that
> value 2.56 becomes 2.00.
>
> If I look at that table in Access or SQL plus, it does have all the
> decimal places but for whatever reason, Crystal 9, truncates it.
>
> It doesn't appear to be a formatting option as I've investigated that
> but I am now at a loss.
>
> Any help would be much appreciated.
>
> Thanks
>
>
|
|
|
|
|