Report Total (1 Viewer)

[mark curtis]

I have a report that calculates sub totals for each department on a report and formats each department by forcing a new page after the sub total. I want to place the grand totals for all the departments directly under the last department sub total. I can do this in the report footer but it is on another page.

 

[Former]

Instead of forcing a page break after the sub total, try forcing a page break before the next department. This should give the desired result.