remove unwanted zeros in Btrieve number field

[65goatman]

I am reporting off of a btrieve table via ODBC, that has a field that is formatted as a 1-integer in the Btrieve table. When I report off of the field, I get the correct number, then two zeros, a decimel point and two more zeros in the Crystal report. When I import the field into Access, and point the report to the Access table, it imports correctly. An example;

Btrieve table (1-Integer)-----------1234.5600
Access(number, single)--------------1234.56
Crystal via ODBC--------------------12345600.00

I want to be able to report off of the "live" btrieve table and avoid the import process within Access.

Any ideas?
Thanks,
Steve

 

[synapsevampire]

Try applying the Crystal service pack/hotfix for your version of Crystal.

You might also try changing your ODBC driver.

-k