Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Summary vs group footer
Message
 
 
To
24/07/2007 19:25:45
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01243318
Message ID:
01243350
Views:
32
This message has been marked as a message which has helped to the initial question of the thread.
>>- 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?

See Re: Form Feeds in report designer Thread #669987 Message #671003

E.g. NVL(_VFP.SetVar(...),'') + NVL(_VFP.SetVar(..),'') to set two variables.

After I re-read your original question I see that I tried to put more into it when you actually asked for.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform