Need page break between subreports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with three unrelated subreports. I need a page break at the
end of the first two subreports.

Other post have problems of extra page between theirs but I could not
determine how they were doing it so I could put a page break.

Thanks for any help.
 
Karl, how about putting the 3rd subreport into a section of its own?

In report design view, open the Sorting 'n' Grouping dialog (View menu.)
Choose the primary key field (since it repeats every record.)
In the lower pane of the dialog, set Group Footer to Yes.
Access adds a group footer section to the report.
Move the subreport into this new section.

Right-Click the section (the grey bar in design view), and choose
Properties. Set the Force New Page property to:
Before Section.

You will now have a page break before the 3rd subreport begins.
 
KARL said:
I have a report with three unrelated subreports. I need a page break at the
end of the first two subreports.

Other post have problems of extra page between theirs but I could not
determine how they were doing it so I could put a page break.
Click to expand...


Did you try inserting a PageBreak control in the main
report?
 
Back
Top