Replace Report page headers with Sub Report headers

[Guest]

I can create the appearance of page headers in a sub report by using
Grouping. What I cannot seem to figure out is how to supress the main form's
page header after the sub report takes over.
The main report will probably (sic) always be less than a page. The sub
report is running 45 to 63 pages. So, I get the column headers for the main
report repeated.
I can't find an event in the sub report to change the main page header that
doesn't affect the first page.

Any ideas will be considered. I am currently thinking of trying to turn it
upside down by making the main the sub and the sub the main and see if that
helps.

 

[Allen Browne]

Hmm. That doesn't sound easy, Dave.

If the main report was always < 1 page, you could use its Report Header
rather than Page Header, so it appeared on the first page only.

If that's not possible, the first thing that comes to mind is some kind of
2-level grouping on the main report. The outer level has no group header,
and the subreport goes in its footer. The inner group has a Group Header
with Repeat Section set, so it acts as a quazi-page header. This inner group
will repeat if the main report runs onto multiple pages. Once it gets to the
outer group's group footer (the section that contains the subreport), it is
no longer under the inner group's repeating header, so effectively the main
report's quazi-page header is suppressed.

That's completely untested, but hopefully a useful direction.

 

[Guest]

Thanks, Allen. I will play with it and see what happens.
One idea I had over night is to change which is the report and which is the
sub report.
As it is, the sub is in the report footer of the main. I am thinking that
if I reverse that, I can put the new sub in the report heaser of the main.
Then i can use either the new sub's report header or the high level group
trick to give it what would appear to be a page header. But, I haven't
tested that, either.
I will be happy to share the results with you, if you have an interest.

 

[Guest]

Got it. I was making it too hard.
I did reverse the two and make the sub the main.
Then, all that was necessary was
Put the sub in the main report header
Replicate the main's page header in the sub's report header with the changes
that differentiate the two
Set the main report header Force New Page to After Section
Done deal.

The only thing I have to live with is I wanted the exceptions to start on
the same page, but I had to make it start on a new page. But, to quote Mick
Jagger, "You can't slways get what you want"

Thanks for responding.