Running total in page footer

[bascy]

Hello,

I'm printing an invoice from two dbf-tables.
If the report is longer than one page i want a subtotal in the page footer, on the last past i want the grand total.

This is what i'v done:
I created two page footers, overlaying, one shows when Pagenumber = Totalpagecount (i.e. the end page), and the other shows the subtotal, which is a running total of the price-field of each line.

THis is what's happening:
The subtotal appears ... but it includes the price from the first line of the next page! When i added the recordnumber to the page footer, it still (correctly) showed the recordnumber of the last record of the first page.

How can the report add the price to the subtotal ...before its reading the record?????

anyone got any suggestions?

 

[FoxG]

Hi ,

Does it still do this if have a single footer section, and suppress the fields instead?

Geoff

 

[Dond12]

Have you tried creating a variable that holds the page total and another variable that reinitializes the page total variable to zero? This would probably work. Place the page total variable in the footer, and directly beneath it put the (suppressed) reinitialization variable.