Keeping group footers together.

[stappawho]

Hello,

I am having trouble getting a report to format like I want. I have the report grouped on 3 fields with each having a header and footer. The footers contain some summary data. The 3 groups in order are (Team, Funding Source and FYQTR)

The report starts a new page between Teams and Funding Source but not FYQTR. I have the report set to start a new page after the Funding Source footer which works fine, the problem is that after the last Funding Source within each team, it starts a new page so the Team footer is on it's own page. I would like the Teams footer to appear directly after the last Funding Source for that Team.

Any ideas?

 

[Brianwarnock]

What if you start a new page before the Funding source header.

Brian

 

[vbaInet]

You would probably also need that Before Teams too, not After.

 

[Brianwarnock]

Not convinced about that, but wouldn't bet against it.

Brian