[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 711
  • Last Modified:

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)
0
ouestque
Asked:
ouestque
  • 3
  • 2
1 Solution
 
Jeffrey CoachmanCommented:
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 CoachmanCommented:
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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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
 
Jeffrey CoachmanCommented:
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

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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