How to insert page break after change in detail section on a report?

[josh_m]

so you know how in excel when you do the subtotals wizard you can insert a page break after each change in a field...I basically want to do that in an access report (access 2007). In the detail section I have a field for "Stores" which can have anywhere from 2 to 50 records per store. I want a page break inserted after each change in store. I am hoping this is simple, I just can not find a thread that quite addresses this issue and can't figure it out on my own.
thanks,
Josh

 

[beifert]

Open report in design view with properties window open, select detail section, on properties - format tab - change "Force New Page" to "After Section". This should give a new page for each Store.

 

[josh_m]

thanks so much for replying, i did try that and the result was each record became its own page, rather than grouping records by store like I had hoped.

 

[beifert]

Sorry. I did not test well.

I assume the report sorted by store. Go into design mode and click "Group and Sort" on Design tab to show the sorting on the bottom. Click "More" on that sort line, change "without a footer section" to "with a footer section". That will add a "Store Footer" below the Detail section assuming the sort or Group is called "Store". Then insert a "Page Break" from the "Controls" section in that footer.

I tested this on a report I had that sorted by date and it grouped all of the same dates on one page.

 

[josh_m]

thanks, I have not tried that. I noticed when trying your first suggestion there was another option for "before selection" and that forced the report to display only one store's data per page. thanks for you help

 

[Aryan]

I have find out one way to get resolve this issue.
1. First If you have not define any group header/footer then define it
2. If you require your page to be break afetr the group then you must need to define your group footer either if it is of zero height or with not field in it
3. Select the group footer by clicking on it and then set the property "Force New Page" = "After Section" this will definitely work for you

Note that this could be done in the same manner if you desire to have the page break before the group details then select the group header insted on group footer and do the same

Regards
Aryan

 

[linda47mi]

Aryan,

I have been struggling with this issue for 2 days. Thank you so much for your answer. It solved my problem!