General information
Category:
Reports & Report designer
>- Create a report variable called rnEmployees, set the Calculate option to SUM, and set the expression to 0 (Yes, zero).
>
>- In the OnExit Expression of the data group footer band, put the following expression: _VFP.SetVar('rnEmployees', rnEmployees + Table.NoOfEmpField)
>
>- In the Report Summary band, use rnEmployees to print the total employees.
>
>
>In case you're wondering, there's a reason I said the Group "Footer" and not the "Header". If you reprint the header when it overflows, you'd end up getting extra hits to your sum.
Thanks Cathy, this seems to work and I sort of actually understand it. Is it true that you can only run one command in the OnExit Expression? What would you do if you needed to deal with more than one variable?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only