Access: 2 subreports. Start a new page if second one to big

I have a report with 2 subreports (Both in the Detail Section). When the second subreport has a lot of rows it will show on the first page, then the rest of the second subreport will show on the second page.

How do I make it so that if both the first and second subreport do not show on the first page, that the second subreport will start on the second page. (Instead of it starting on the first page and carrying over to the second page, as described above)
ouestqueAsked:
Who is Participating?
 
irudykConnect With a Mentor Commented:
One possibility would be to add a Sort/Grouping category (e.g. group on a Field that is unique to the table/query source) and give that group a Group Header.
Next, move the Revenue subreport in this new group header.  Then in the properties of this new group header as well as the existing Detail section, ensure that the Keep Together attribute is set to Yes (along with the Can Grow and Can Shrink attribtutes).
0
 
Jeffrey CoachmanMIS LiasonCommented:
ouestque,

"How do I make it so that if both the first and second subreport do not show on the first page, that the second subreport will start on the second page."
?
I'm confused?
So what do you want on the first page?
0
 
Jeffrey CoachmanMIS LiasonCommented:
ouestque,

Try inserting a manual page break (From the Toolbox ) between the two sub reports.

This way, the second sub report always starts on a new page.

JeffCoachman
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
ouestqueAuthor Commented:
My apologies. I meant "fit on the first page", In other words. If both subreports do not fit on the first page, start the second subreport on the secondpage. (Instead of the second subreport, starting on the first page, then bleeding over to the second page.
0
 
ouestqueAuthor Commented:
i.e. If one subreport was "Revenue" and the other subreport was "Costs". I would want to see both the "Revenue" and the "Costs" on one page if they will fit on one page. But if they don't fit on one page, then show "Revenue" on the first page and show "Costs" on the second page.

Currently they don't do that. If there are a lot of "Costs", then "Costs" will start right after "Revenue" on the first page, then continue on the second page.
0
 
Jeffrey CoachmanMIS LiasonCommented:
ouestque,

Can you post a sample?

Whenever I create a main form with subforms, I group the report by the Uniuqe ID, as irudyk, states, and by default, the sub report will not start to print on the same page as the group starts, unless there is enough room to finish.

JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.