Page Headers on Subreports

[Tim Dolloff]

I'm using Access 2000 and when I try to use a Page Header
on a subreport, the page header doesn't show up when I
view the main report. I found an entry in help that
indicates that this is on purpose. Does anyone know a way
for me to get around this? Here is the scenario as to why
I need to do this:

I'm attaching 3 subreports to the main report. When each
subreport is viewed alone, it has a page header on each
page and 3 groupings of data on each page. I essentially
want to be able to view and print all 3 of these
subreports as a single report.
If I set group headers instead of page headers on the
subreports, then my column headers are repeated 3 times on
each page. If I use report headers, then I only have
column headings on the 1st page of each subreport.
If I set page headers on the main report, then I have the
same column headings on every page of the report, when
there should be different column headings for each of the
subreports.

 

[Rick Brandt]

I'm using Access 2000 and when I try to use a Page Header
on a subreport, the page header doesn't show up when I
view the main report. I found an entry in help that
indicates that this is on purpose. Does anyone know a way
for me to get around this? [snip]

Add a group header as the first grouping option to the sub-reports using something
like =1 as the grouping expression. Then set this header's "Repeat Section" property
to true. It will look and act much like a Page Header, but will still work in a
sub-report.

 

[Tim Dolloff]

Thanks so much! That worked perfectly.

-----Original Message-----

I'm using Access 2000 and when I try to use a Page Header
on a subreport, the page header doesn't show up when I
view the main report. I found an entry in help that
indicates that this is on purpose. Does anyone know a way
for me to get around this? [snip]

Add a group header as the first grouping option to the sub-reports using something
like =1 as the grouping expression. Then set this

header's "Repeat Section" property