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