Here's something that should be fairly common in reports, yet I can't find a way to do it.

I'm working on a report with subtotals for multiple groups, e.g. Company, Branch, Department, Salesperson. The requestor wants a page break between each Department, but they want the Branch subtotal to appear on the same page as the last Department in that Branch.

If I select New Page After on the Department group footer then the Branch subtotals appear on a separate page-not what is wanted. If I leave it off the Department group footer then I don't get the wanted page breaks between departments.

Either I'm missing something or I need to use a formula to control the page breaks & I can't figure out what it would be.

Advice?

Thanks.

Thanks. I got a solution from a co-worker using New Page Before in the group header, but I think this solution will solve some other problems I'm having (like having the Salesman group name in both the group header, so it appears in mid-page when the salesman changes, and also in the page header so it is repeated at the top of the next page when the salesman's detail listings span multiple pages).

I'll play around with the Next function & hopefully remember it for the future.