Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Page End rounds up the values
Message
De
02/04/2003 05:52:07
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00772782
Message ID:
00772868
Vues:
16
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform