Check SET('DECIMAL') just prior to running the report and make sure it is at least 2.

Cathy

>Hi Cathy,
>I checked the data in the table itself and it does show the correct decimal information. I changed the format of the End of Page sum to a character instead of numeric currency and it shows the correct figures but another field on the same report does not even though I changed that to character format as well.
>Thanks
>Max
>
>>Just before you print the report, browse the table and confirm without a doubt that the numbers are as >you expect and not rounded in the data.
>
>>Cathy
>
>>Good day everyone,
>>I have a report that seems to round up the values at the end of a page. If a field in the Page Header has a value of 106.16 then the bottom of the page (which is supposed to sum the fields on that page) gives a total of 106.20
>>In the Report 'Page Footer' I have a field that Sums at "End of Page" and the field is supposed to be a currency so I set it to Numeric currency in the format "@$ 99999.99"
>>The Field in the "Page Header" has the expression
>>
>>IIF(table1.field1<>0,table1.field1,"")
>>
>>and I don't have any format on it. I guess it's rounding to the tenths place but I don't know how to change it!
>>Can someone please help me so I can get it to give the exact sum and not round up.
>>Thanks!
>>Max