Page Break on Group Footer not working?

Trying to set a "page break" on Group Footer #4, however the DepartmentRecap info on the Group Footer with the Check Amount are showing on the employee page and then the details on the next page.

I have it set on New Page After the formula NOT OnLastRecord

Tried it just checking the New Page After also

Same results.

Not sure why the Group Footer line isn't staying together with the details on the next page?

I've also tried Keep Together

Where have you tried "Keep Together"? It needs to be on the Group AND the section.

When you use the formula "not OnLastRecord" are you also checking the New Page After checkbox? If so, uncheck it.

-Dell

I checked Keep Together in both Section AND Group

The NOT OnLastRecord doesn't seem to be working.

There are other formulas in the New Page Before in the 2x PR_AuditReport

Thanks for posting the report! This would have been much harder to diagnose without it!

Looking at the report, you do NOT need "formula =" in the formulas in the Section Expert - just leave the rest of what you have that evaluates to True or False.

Looking at what your formulas are doing, it looks like you want a new page before based on a set of conditions AND new page after based on a condition that is part of the set for New Page Before. Is that correct?

You've also got some overlap with fields in the Suppress formula.

Suppress:  {@SortReportBy} <> "E" or {@Departments} = "N" or {PR_DataEntryAuditWrk.ReportSection} <> "A"



New Page Before:  {@SortReportBy} = "E" and {PR_DataEntryAuditWrk.ReportSection} = "B"



New Page After:  {PR_DataEntryAuditWrk.ReportSection} = "B" and NOT OnLastRecord

Because of the 'or {PR_DataEntryAuditWrk.ReportSection} <> "A"' part of the suppress formula, the section is going to be suppressed. If the section is suppressed, the "New Page Before" and "New Page After" will also be suppressed. Also, if you want the new page after only when the report section is B, if there will always be report sections that are after b, you don't need the "OnLastRecord" part of that formula because the report will never be on the last record when report section = "B".

-Dell

Yes on the New Page rather before or after, not sure.
Thinking it's New Page Before section that needs to be modified.

I've removed the New Page After formula as it's not really doing anything with or without it. Original is without anything here.

As you saw, in GF4, Department Recap (red font) displays at the end of each department. Although the details are showing on the next page. Can't figure out how to have the GF4 Department Recap info (red font) show at the top of the next page with the department recap details.

Not sure how to modify the formula so that GF4 shows at the top of the new page along with the details. The details are showing on a new page but that the GF4 info (in red font).