A Crystal report gets data from an Oracle DB based on a SQL query (in "Command"). There is a "number" field which stores values in negatives and 2 decimal places. When running the SQl alone it shows the number w/o any problem e.g.
-32.23. However, in Crystal it displays as -32.00. Even changed the number format to -1230.00 it still shows the same thing.