Rounding error

[ksbigfoot]

I am using Crystal Reports 10.
I view the query my report is using and when I run it through Query Analyser it shows the values to be 3.5
But when the value is placed in the details area, it is displayed as 4.00
I have formatted the field by clicking Format Field -> Customize.
Decimal 1.00
Rounding 0.01
Not sure why it is not displaying 3.50?

 

[Madawc]

Makes no sense, it definitely should work.

First try checking the data. In field explorer, you can right-click on a field and say 'browse data'. Maybe it is somehow coming out different.

Or is there some intermediate?

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[ksbigfoot]

Howdy Madawc,
That is what I thought. It should work.
When I view the query the form is using it shows 3.5.
I did a formula and converted it to a string and printed it out and it comes out as 4.0.
I am going to play with changing my query to import the value into different fields (AS newValue1) and play with that value. I will post my solution when I find out what is happening.
ksbigfoot