How to display the decimal fields from Views

[SangeethaEdward]

hello

I am using Crystal report 9.0 for reports. I have a table in ORACLE with decimal(5,2). I made a view on the table with the decial field and that view is used in crystal report directly as view. While displaying the field , Crystal is not displaying the fraction part, it is truncating the fraction part and just displaying the integer part.
Eg. Table value is 2.7
In crystal displayed as 2.00
But If I use the table directly, I get the decimal value properly. But I need to create the view for my purpose. Somebody please help me solve this problem.

Despirate for help!!

 

[MColeman]

Sometimes, when I've changed a view that is already used in the report, I have to run the verify database option inside the report.

Or, it could be the format on your field. It may be rounding based on an older definition?