rounding issues 1

[mehlerak]

Using CR 9 Pro connected via ODBC to Oracle. For some reason some fields are getting rounded to the nearest dollar. This is not happening in other applications using the ODBC connection. Formatting the field shows it is formatted to use a setting with 2 decimal places.

thanks

 

[synapsevampire]

You're probably using the Oracle supplied ODBC driver, which you are NOT supposed to do with Crystal.

The first option is Native connectivity, which is supplied by Crystal and shows up ass Oracle Server, the second choice is the Crystal supplied Oracle ODBC driver, which is slower and there really isn';t any reason to use it unless you have a fear of faster queries, the 3rd choice would be Oracle's ODBC driver, which will return bad data and sometimes crash.

That is to say, switch to the native connectivity

-k