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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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
irudykCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.