Negative Numbers display incorrect 1

[faroe]

A colleague is using Crystal v10 to connect to an Oracle database using an ODBC connection.

When inserting a number field into a report the number is displayed as normal if the number is zero or posiive, however negative numbers are shown incorrectly.

For example -5 is displayed as 65531.

(This is consistent i.e. shows as 2 to power 16 'plus' the negative number.

Is this a driver issue?

 

[synapsevampire]

Yes, they're probably using the Oracle supplied ODBC driver, switch to the Crystal supplied ODBC driver, or better yet, use Oracle native connectivity, it's much faster.

-k