keep group footers together on one page

Take this:

1. Use “Keep Together” Property

• Set the “Keep Together” property of each group section (Group A, B, C) to “Whole Group”. This helps prevent group footers from being orphaned on a new page.
• Also set “Keep Together” on the Detail section if needed.

2. Conditional Page Breaks

Use VBA or conditional formatting to suppress page breaks:

• In the Group Footer sections, add logic to conditionally suppress page breaks based on whether it's the last group or nested within another:

If Me.Page = Me.Pages Then
    Me.GroupFooterC.NewPage = 0
Else
    Me.GroupFooterC.NewPage = 1
End If

3. Custom Footer Aggregation

• Create unbound controls in the Report Footer or Group A Footer that manually calculate and display totals for B and C.
• Use DSum or custom logic to aggregate values.

4. Use Subreports

• Create subreports for each group level and embed them in the main report.
• This gives you more control over pagination and layout.