Unintended Truncation of number

[pelajhia]

Howdy.
I am accessing a number(9,2) in an oracle 8i database using Crystal Rep 9.
I have never noticed this happening before, but none of my cents are coming back ( instead of 638.22, I get 638). I have a nested query and the number is being summed, but other than that, things are pretty straight forward.

Any suggestions?
Thanks!

 

[crystalreporting]

If you're using ODBC, check for any settings in the ODBC configuration, for your driver.

 

[pelajhia]

I did not see much in the settings that looked like it was going to help, but your idea did get me to realize that the odbc driver I'd used for this particular connection was a MICROSOFT ODBC driver for Oracle, rather than an ORACLE ODBC driver. I switched this out and the fields came back with pennies attached!!
Thanks!

 

[synapsevampire]

Presumably you're not rounding the number when it's being displayed. The Crystal default may also be set to round off decimals (File->Options->Fields->Number->Number->Customize).

Also make sure that you use the CR supplied ODBC driver, not the Oracle ODBC driver.

There are also hotfixes which should be applied monthly:

http://support.crystaldecisions.com/fix/hot/si75/?ref=default.asp_selectlist

-k

 

[pelajhia]

I did not realize there is a crystal supplied driver...but now that you mention it, I see the group of 'CR' drivers. Just never noticed before.
I will give the oracle one a try next chance I get. Thanks for the tip.