No Page headers?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a main report and a subreport. The subreport has page headers which
are visible when it is run on its own. However when I include it in my main
report as a subreport then the page headers don't show? Anyone suggest a
reason. Also the main and sub reports aren't linked on any field because the
main report just has controls which are record counts where as the subreport
has record detail. Both reports are based on the same date parameters
though. Could this be causing the problem?
Thanks
Tony
 
Tony said:
I have a main report and a subreport. The subreport has page headers which
are visible when it is run on its own. However when I include it in my main
report as a subreport then the page headers don't show? Anyone suggest a
reason. Also the main and sub reports aren't linked on any field because the
main report just has controls which are record counts where as the subreport
has record detail. Both reports are based on the same date parameters
though. Could this be causing the problem?
Click to expand...


That's normal. Because the main report is "in charge" of
page related actions, the page header/footer and Page event
in subreport is ignored.

Can't you just move the subreport page header controls to
the main report? If not, create a top level group header
based on a constant expression such as =1 in the subreport.
Move the page header controls to this group header section
and set the section's RepeatSection property to Yes. (Note
that this concept does not apply to simulating a page
footer.
 
You don't get page headers or footers in Access reports. Don't know why,
just is.
You can fool it by creating a group level. It should be the first group
level and all you need is =1 in the field/expression for the group header.
It will now act just like a page header.
 
That's the way it's designed, Tony. When you have a subreport, anything in
its Page Header or Page Footer is ignored, and Access uses the header/footer
from the main report.

One workaround is to create a group header in the subreport that is always
the same. In the Sorting And Grouping dialog, enter the field:
=1
and in the lower pane of the dialog, set the Group Header to Yes. Then set
the Repeat Section property to Yes, and it repeats on each page.
 
Back
Top