Oracle Number data type retrived with decimal points. 1

[Maniyur]

I am using Crystal Reports 8.5 with Oracle 9.2.

While retrieving data using ODBC (CR Oracle 8 v3.6 / MS ODBC for Oracle) the number datatype is retrieved with two decimal points..for example, value 4000 in databse shows up as 40.00.

I am not sure if this is a problem with ODBC driver?

Please help.

 

[mmaz]

The decimals are the default for numbers. You can change it using "Format field", I believe.

 

[Maniyur]

I did try "Format Field" in Crystal. It does not work.
It suppresses the last 2 digits. ie, 4000 is diplayed as 40 when I change the format.It should show up as 4000.

 

[mmaz]

Weird. What did you do exactly?

 

[Maniyur]

These are the stepe I took for formatting.

Right clicked on field. Chose "Format Field". Under "Number" tag chose the format without decimal points.
Eg: -1123. Also I did the same setting using the "Ooptions" Menu.

Looks like when the report gets the value it adds those decimal points automatically.

 

[synapsevampire]

I would apply the current hotfixes/service pack as this is a known issue:

http://support.crystaldecisions.com/library/kbase/articles/c2009709.asp

Hotfixes:

http://support.crystaldecisions.com/fix/hot/si75/?ref=default.asp_selectlist

-k

 

[Maniyur]

That fixed it.

Thanks much for this help.