• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 876
  • Last Modified:

Starting each sub report on a new page

Hi
Using Access 2010. I have a main report, with five sub reports. Each sub report has four reports in it. Lets call these "Section Reports". The four reports can vary, the logic for selecting which four is in the sub report.
I want each section report to start on a new page. I am aware that page breaks do not work in sub reports. And I don't want to move all the logic into the main report. So I came across a solution on Experts Exchange - Use Sections
The solution states you should use Force New Page in the Group. I've tried this, but its not working for me, there is no new page. I've attached a screenshot of my settings.
Any ideas on how I can get around this?
Thanks
0
jdhackett
Asked:
jdhackett
  • 5
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You didn't attach your screenshot.

The four reports can vary, the logic for selecting which four is in the sub report.
What do you mean by "selecting"? Do you mean that your subreport would only show one of those sub-subreports? Or that it could show one or more of them?

Have you tried the group at the first subreport level? That is, not the main report (that houses your first level of subreport), but in that first level of subreports?
0
 
jdhackettAuthor Commented:
I've attached it now, thanks.
The sub report could show between one and four of the sub-sub reports.
The New Page on the Grouping does seem to work better if I try it at the first level of sub report. It would be handier if the grouping New Page  worked at the lowest level though. Is that possible?
GroupHeader.JPG
0
 
PatHartmanCommented:
Access has a page break control and that might solve the problem.  Add the control between the subreport controls to force a page break at that spot.  I haven't tried this so I'm not sure how it will work if any of the subreports go more than one page in length so please test thouroughly.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
jdhackettAuthor Commented:
Hi Pat
Page breaks don't work on sub reports. As I mention above, this is why the other Experts Exchange article suggest using section breaks.
0
 
PatHartmanCommented:
I wasn't referring to the page break property.  I was referring to the page break control.

Page Break control
0
 
jdhackettAuthor Commented:
I know. Page break controls have no effect if its in a sub report.
0
 
jdhackettAuthor Commented:
Never followed up on my additional question.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Was your question answered? I don't think it was, and my comment was more of a shot in the dark than a solution.

If the comment didn't resolve your question then you should just delete it. You shouldn't award us points if we didn't help.
0
 
jdhackettAuthor Commented:
Hi Scott
I figured it out from your post, so you deserve some points. Using the Group on the first level of sub reports only.
Regards
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now