I have a report with multiple breaks. For simplicity sake, I'll keep the question refined to three breaks:
Plan Footer (new page)
Location Footer (new page)
Group Footer (Group totals > inserted page break > fancy page finalizing group)
My problem: When the last Location comes in for the Group, I don't want a page break. I want the Group totals to appear directly under the location totals, then, the inserted page break will take care of printing the fancy page all by itself. How do I prevent the final Location within the group from breaking a page? Is there an event that the last Location will trigger that I can interrogate?
e.g., If Location.Last_Record = true then
else new page