Force Page Break on Report

[illini]

I have a report which sorts records by state. I would like to force a page break in the 'Details' section with each unique state. Therefore, a group of records for three separate states (which currently fits on one page) would now be displayed on three separate pages.

What is the best way to achieve this?

-illini

 

[mmayo]

Good morning, illini!

Yes this can be done. Open your report in design view and make sure you have selected states as a field for sorting and grouping. Choose to have a "Group Footer". Right click on the bar that says something like "State Footer" (you don't have to have any data in this section). Go to properties, and you'll see the option to "Force New Page", select "After Section" and your report will print one page for each state.