Why is my decimal point not in the correct location?

[wilburn]

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!

 

[synapsevampire]

What ODBC driver are you using? If racle or SQL Server, make sure that you use the CR supplied drivers, not the MS and Oracle. And keep your service packs up to date.

-k

 

[synapsevampire]

I found the whitepaper:

http://support.crystaldecisions.com/library/kbase/articles/c2009709.asp

-k

 

[wilburn]

Microsoft Visual FoxPro Driver