In order to do this kind of operation, put a formula in your Details section that looks like:
WhilePrintingRecords;
Global NumberVar PgTotal;
PgTotal = PgTotal + {MyReport.SalesValue};
In the Page Footer section, put this formula:
WhilePrintingRecords;
Global NumberVar PgTotal;
PgTotal;
In the Page Header section, put this formula:
WhilePrintingRecords;
Global NumberVar PgTotal;
PgTotal = 0;
Here's what this trio of formulas does:
At the top of every page (including the first page, conveniently), the running total is set to 0. With each record, that record's value is added to the total, summing up the values. At the bottom of the page, the current value is displayed.
IP Logged
