lost decimals Oracle8 - CR8

[daaf]

Hello,
Using a Odbc connexion, CR8 trunc all numbers ...
I've test my ODBC Connexion, all decimals are presents,
when I put this field on my report I can't see any of them.
I've made a formula with myfield*100, it's just like it was a integer and not a decimal field ...

Help me please ...

Daaf
(sorry for my english, I'm french...)

 

[HowardHammerman]

It is possible that the particular ODBC driver you are using cannot handle decimals. I have used Crystal with Oracle and had no problem with decimals. Perhaps you have a default setting to format without decimals?

Right-click on a numeric field and select format. Pick a format with decimals. If that fixes the problem for one field set the option for all fields. Click on File | Options | Fields | Number | Number Tab
and pick the format you want.

Voila' C'est bon? Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[daaf]

OK I solved it in changing language of the "register data", All parts are in american and I get my decimal back ...

Thanks for help ...

daaf

 

[HowardHammerman]

Glad to help!

Howard Hammerman,

Crystal Reports training, consulting, books, training material, software, and support. Scheduled training in 8 cities.
howard@hammerman.com

http://www.hammerman.com

800-783-2269