I have a report containing a number of numeric columns. The report groups the data and produces subtotals on each change of group and a grand total at the end.
I also need to print in the page footer a total of only those records printed on the page above but I cannot figure out how to do this. Can anybody help please?
Group 1
Rec 1 100.00 200.00
Rec 2 100.00 200.00
Group 1 Total 200.00 400.00
Group 2
Rec 1 100.00 100.00
Page Footer 300.00 500.00
Group 2
Rec 2 100.00 100.00
Group 2 Total 200.00 200.00
I also need to print in the page footer a total of only those records printed on the page above but I cannot figure out how to do this. Can anybody help please?
Group 1
Rec 1 100.00 200.00
Rec 2 100.00 200.00
Group 1 Total 200.00 400.00
Group 2
Rec 1 100.00 100.00
Page Footer 300.00 500.00
Group 2
Rec 2 100.00 100.00
Group 2 Total 200.00 200.00
