Frustrated with page break in report between groupings

mulberry13

Board Regular
Joined
Nov 23, 2005
Messages
204
I have a report that I have asked for "grouping" by "teacher" with a total under end of the teachers list which is working fine but I want there to be a "page break" between the teachers and their total kids. I inserted a "page break" in the "teacher footer" but no matter what I do it still prints them with no page break between teachers. help
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
If you want the page break, just remove that page break, go to the Teacher HEADER and select it in design view and find the property FORCE NEW PAGE and set it to AFTER SECTION.

Most of the time you can deal with it without the page break object. But the reason why it isn't working for you is that in the footer it includes the details and breaks after those, so you want the header if you want the teacher separate from the students.
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top