New Page between subreports

cwbarrett
cwbarrett used Ask the Experts™
on
Hi,
I have a main report having 4 subreports in the details area.  Each sub report needs to begin on it's own page.  Each subreport has a "force new page" in the Details property area but it doesn't begin a new page.  All 4 subreports end up being contiguous.

Is there a way to make each subreport start on a new page?

Help is most appreciated.
Charlie
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Distinguished Expert 2017
Commented:
Try inserting a page break control between the subreports.  It is on the ribbon for A2010 between the Option Group and the Combo.

Author

Commented:
Excellent, solved, thank you.

BTY, the report footer prints immediately following the last subreport.  Any way of forcing it to print at the bottom of the last page?
Distinguished Expert 2017

Commented:
I don't have a solution handy.  I think you need to examine the height of the detail section and add blank rows until you space down enough.  Good luck with it.

Author

Commented:
Thanks.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial