Report SCR8 ODBC Oracle8 show zero in decimal places

[cpagnani]

I'm writing a report with SCR 8 accessing Oracle 8 database through Oracle ODBC driver and Oracle client 8.0.5.
The report reads a database field number(6,2).
Field value is 1234.56 but the report shows 1234.00.
Same report with native driver or MERANT ODBC Oracle driver works correctly.
What's wrong???
Thans
Bye
Claudio [sig][/sig]

 

[kenhamady]

One possible solution.

Click on the field and use the menu commands
Format - Field.

Go into custom format, and check the rounding setting.
It could be that the default rounding is 0 even though the default display is 2 decimals. Possibly taken from the Windows default.

This can be changed globally in File Options, on the fields tab.

[sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[cpagnani]

Format seems correct: decimals 1.00, rounding 0.01.
Same report on another PC with same version of Oracle Client works properly.

Thanks
Ciao
Claudio Pagnani [sig][/sig]

 

[kenhamady]

To identify wether the problem is truly ODBC or Crystal, can you read the data using MS Access through the same ODBC driver? If Access gets the same result, then the problem is in the ODBC layer. If Access gets the decimals, then you have a very strange Crystal problem.

Is it rounding or truncating? The example you gave was a truncation, but that may have been accidental. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[cpagnani]

MS Access don't get the decimals so the problem is in the ODBC layer.
It is always truncating. I chose the example to show that.

Thanks for suggestions
Ciao
Claudio Pagnani [sig][/sig]

 

[dsdata]

Hi, I'm writing from Italy, I have the same problem with Oracle 8.1.7.
I have seen that the problem is the decimal separator and the thousand separator: if I set from the control panel the international setting from Italian to English it works well.
In fact in Italian the separators are opposite from English.
There's a problem: all other applications (like Excel, Word...) don't work well...
Please tell me if you have another solution.
Thank you
Gabriele

 

[cpagnani]

I worked around the problem by turning all my reports to native Oracle driver.
Sorry I can't help you.
Ciao
Claudio

 

[dsdata]

Please, can you explain me how did you make it?
If you are Italian can you tell me it in Italian?
Thank you very much.
Gabriele

 

[cpagnani]

File -> Database -> Convert database driver...
from: pdsodbc.dll [ODBC]
to: pdsora7.dll [ORACLE 7.x]

Versione italiana
File -> Database -> Converti driver database...
da: pdsodbc.dll [ODBC]
a: pdsora7.dll [ORACLE 7.x]

Ciao e buon lavoro
Claudio