Grouping subreports to a page

  • Thread starter Thread starter Matthew Pryor
  • Start date Start date
M

Matthew Pryor

I have a report with multiple sub reports inserted which
can grow and shink depending on the number of records
returned. I would like to try to ensure that the data from
each sub report is always kept together and does not 'roll
over a page' if the previous sub report ends near the end
of a page. Is this possible!?,

Many thanks

Matthew
 
Yes, it is possible if you place each subreport into a section of its own.

1. Open the main report in design view.

2. Open the sorting'n'grouping box (View menu).

3. In the upper pane of this dialog, choose your primary key field.
In the lower pane, choose Yes for both Group Header and Group Footer.

You now have 3 sections that occur for every record: a group header, a group
footer, and the Detail section. Place one subreport in each one. Set each
section's KeepTogether to Yes. The subreport prints, breaks (since it's the
end of a section), and then the next one will keep together (which may mean
it goes to the next page).

If you have more than 3 subreports, choose the primary key field again on
the next line of the dialog, to create yourself 2 more sections. Repeat as
needed.
 
Allen, I appreciate this very creative solution. I was pulling my hair out
over this problem (not that I have any left...). Thank you!

James Carpenter
 
Back
Top