Can't retrieve decimals ... CR8 - ODBC - Oracle

[daaf]

Hello,
Using a Odbc connexion(Oracle 8 ODBC Driver), CR8 trunc all numbers ...
I've test my ODBC Connexion (with ODBC test), all decimals are presents,
when I put this field on my report I can't see any of them (I think I've try all formating solutions - default format, personalized format ...).
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...)

 

[Naith]

Hi Daaf,

Is this field in customised format?

(Format Field, in Format Editor, Click Number tab, Select Custom Style, Click Customize.)

Here, ensure that the decimals attribute is set to 1.00, and rounding is 0.01.

If it is, can you tell me if values are returned when you use the Remainder formula on your field like this:

Remainder ({Your.Field}, 1)

 

[daaf]

Done,

It returns 0,00 ....

Thank you for help

 

[daaf]

I think I resolve the Pb ...

I change language used by Oracle Custumer in american, so it seems to work ....

Thank you

Daaf