Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Page End rounds up the values
Message
From
02/04/2003 05:52:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00772782
Message ID:
00772868
Views:
17
>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

Can you add a numeric format to this? Perhaps you should just change the expression to Table1.Field1, and use conditional printing.

Sometimes the reporting system will round to less digits, if there isn't enough space to show all the desired digits.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform