Oracle and Crystal Reports

[virtualmod]

I have the problem when I include a numeric column (int or number) from my Oracle DB in the Crystal Reports the numbers have always two decimal places by default.

Seagate knows this bug and released a fix for it but it didn´t work.

Knows anybody a fix for this prob ?

[rmgirma]

In crystal Reports, right click on the number field and select "Format Field", go to the Number tab and change the 1.00 to 1 under "Decimals". The default value is 1.00.

If you would like to change the default setting for Crystal, Go to File, Options, Fields, Number, Number Tab, and change the 1.00 to 1 under "Decimals".

[virtualmod]

Thanx....but this is not the problem.
The prob is that i must join the column with a column from a MS SQL-DB and that didn´t work cause the decimal places.

[rmgirma]

Have you tried to get rid of the decimals before joining the tables ? Try the TRUNC function of oracle.
trunc(table1.field1,0)

Hope this helps.