Crystal is Adding Decimals to values that don't have Decimals 1

[Wenin]

I have a SQL Database that has numeric data-type fields. When I assign the database to a Crystal Report, the data that is being pulled over is having decimals added to the information.

For example, if I have a value in the database equal to "3600", for some reason it sees that value as 36.00. If I have a value in a field equal to 15450. It sees that as 154.50.

Why is this? It is seriously annoying.

I'm doing a hatchit job to get around the issue by removing the "Decimal" seperator and then removing the "Leading Zero". This ends up giving me "01" for values that are equal to "1".

Ugh!!!

I'm using Crystal Reports Version 8. I know it's old, but that's all I have right now, and something like this is so basic I can't imagine it being a bug that shipped with the software.

 

[synapsevampire]

By SQL I assume that you mean SQL Server. WHat connectivity are you using? If native try switching to ODBC or OLE DB, and vice versa.

I don't know of any issues with SQL Server connectivity along these lines, though I have seen the same problem when using the Oracle ODBC driver supplied by Oracle, which went away by using the CR supplied ODBC or the Native Oracle driver.

-k

 

[Wenin]

That did the trick!!

I went to Database > Convert Database Driver > and selected the "OLE DB" driver.

Fixed it!!!

Thank you!