Subreport Runs Inside Another

  • Thread starter Thread starter David Habercom
  • Start date Start date
D

David Habercom

My main report contains 5 subreports in the detail
section. I want them to print in sequence. However, in
cases where Subreport1 is short enough that it doesn't
kick out a page, Access runs Subreport2 before formatting
the footer in SR1. In other words, SR2 code runs INSIDE
SR1. The sequence:
Subreport1 Header
Subreport2 Header
Subreport2 Footer
Subreport1 Footer.
While I have not tested it, I assume that this hierarchy
continues theoretically through Subreport5 until a full
page is printed. After a page is printed, the hierarchy
seems to break up (I think.)

This is an issue for me because I want a "Continued..."
page header to appear whenever any of the subreports,
individually OR in combination, spans more than one page.
I am getting exasperated trying to toggle the Visible
property on the page header at the right time.

My subreports require separate queries, so I can't combine
them in to a grouping of some kind.

If anyone has a clear-headed way to handle this, I would
appreciate knowing it.

Thanks.

David
 
Hi David
if you have sections in your subreports, you can use the
section property 'Repeat Section' set to yes. This will
repeat the section - that can contain column headings - at
the top of the next page if that section/detail continues
onto another page...

Luck
Jonathan
 
Back
Top