I'm using an ODBC connection to a database that has a table with fields that are double with 14 decimal places. I have my report set up to display numbers with two decimal places. If the number in the database is a whole number (nothing after the decimal point like 62.00000000000000), the number in the report is shown as the number divided by 100 (eg 0.62). If in the database there is something after the decimal point (like 42.20000000000000) then the number is correctly displayed as 42.20 in the report.
I'm using Crystal reports 8.5.
Thanks!
I'm using Crystal reports 8.5.
Thanks!