Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Summaryband
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
Miscellaneous
Thread ID:
01002555
Message ID:
01002583
Views:
19
Create a report variable called rnTotal and set the value to the field you are totaling. Set the calculation option to "SUM", and the reset option to "Page". Print rnTotal in the Page Footer.

Now create a second report variable called rnPrevTotal, set the value to 0, set the Calculate option to SUM, and set the reset option to End Of Report. Now in the PageFooter OnExit expression, put the following: _VFP.SetVar('rnPrevTotal', rnTotal). Use rnPrevTotal in the Page Header band to print the total from the previous page.

Cathy


>Hi,
>
>Is it possible to print a total of amounts on each page? I mean I have a report that shows money amounts. Now I want a total for each page at the end of each page. And that same total must also be printed on the top of next page. Is something like that possible?
>
>Thanks in advance,
>Ron
Cathy Pountney, Microsoft Visual FoxPro MVP
Memorial Business Systems, Inc. (www.mbs-intl.com)

My Website: (www.frontier2000.com)
My Blog: (www.cathypountney.blogspot.com)
My Book: The Visual FoxPro Report Writer - Pushing it to the Limit and Beyond
Free MSDN Article: What's New in the VFP 9.0 Report Writer
Free MSDN Article: The VFP 9.0 Report Writer In Action
Previous
Reply
Map
View

Click here to load this message in the networking platform