Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multi-page invoice-one total please
Message
 
To
23/01/2004 23:46:41
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00870202
Message ID:
00870546
Views:
8
So if I understand correctly, you want the totals to print in the page footer so it's at a fixed location at the bottom of the page .. but you only want it to print on the last page. Here's what you can do....

- Create a report variable called "lLastPage" and set the value to: .f.
- Create a data group with the expression of: EOF()
- In the On Exit expression of the EOF() Group Footer, place the following expression: _VFP.SetVar('lLastPage', .t.)
- Use the expression of "lLastPage" in the Print When for all the total fields in the Page Footer.


I hope this helps,
Cathy




>Have Page Header with all the pertinent info (cust/address etc) from one table
>Then details of order qty shipped
>Storing invoice subtotal variable as it goes through the detail table
>Add shipping charges at the bottom (and sales tax) from the first table
>
>Problem is:
>If I print a summary, it floats up (bad) but only prints once (good)
>If I print a page footer and there are so many line items shipped that the details cause a second page, the page footer (with invoice total and sales tax an freight) prints on each page of the invoice.
>
>Any help? Hopefully this is just something simple that I've missed all these years...or did the powers that be actually make pigs fly in v8 as Cathy says in FoxTalk?
>
>Thanks
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
Next
Reply
Map
View

Click here to load this message in the networking platform