Subreport Runs Inside Another

[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

 

[Jonathan Parminter]

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