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?

 

[kenhamady]

What version of CR?
How are you creating the running total field?
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com