SUB Headers appearance issue 2

[teqtaq]

Here is what is happening.

Report has a Page Header:

____________Report__NAME___________

_____________ColA__ColB__ColC___Total

********Data etc....

Report_Footer has 2 SUB Reports with Page Headers:

____________Report__NAME___________

_____________CityColA__CityColB__CityColC___Total

********Data etc....

AND

____________Report__NAME___________

_____________SumColA__SumColB__SumColC___Total

********Data etc....

So - Report names are the same - headers for the column s are differentfor each.

When I am printing - Main Report's Page Headers appearing on SUB Reports.
I had tried to set RH to Not with Rpt Hdr - this way nothing gets printed for SUBS.

I am playing with different options and none seem works. I am sure I am overlooking one that is correct one.
I hope there is one, thank you.

P.S. Desired outcome is each of 3 Reports showing same Report name and different headers per each. Every Report has more then 1 page. Thanks

 

[dhookom]

Subreports don't know anything about page sections and events. You can create a page header replacement by adding a new top level sorting and grouping level in the subreport on a constant like:
[tt] =1 [/tt]
View the Group Header for this section and use it as a page header. Set its Repeat Section property to Yes.


Duane
Hook'D on Access
MS Access MVP

 

[teqtaq]

Brilliant, it works! Thank you so much.

 

[roccorocks]

This does work, however, only on the first page. If you have more than one page, it still only shows on that first page (and not the other 2 that follow). Any ideas? You actually can use the Report Header as well (same result as I mentioned above).

 

[dhookom]

I'm not sure where your results come from but if you follow my instructions including

Set its Repeat Section property to Yes

you should get the =1 group header on each page.

Duane
Hook'D on Access
MS Access MVP