Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SUM() at the end of a report
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00568629
Message ID:
00568638
Views:
19
>Good day everyone,
>I need some help with the syntax for a report please.
>The end of my report has a few calculated fields of the sum of each field of the report. I would like to then sum those fields together for a grand total on the same end page but I am unsure as to how I need to go about it.
>I get an "Syntax Error" when I try the following code as the expression for field on the report:
>SUM(table.field1,table.field2,table.field3)
>I have the "Calculate field" set to SUM at "End of Report".
>
>Thank you!
>Max

Max,
I would suggest adding a report variable that adds the fields together. Set the Initial Value to 0 and the Value to Store as teh summation of the three fields. Then select the Sum radio button. Set the Reset to the End of the Report and you can then add a field to display the variable anywhere in the report.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform