Page Header repeating on every page of subreport

[Guest]

I hope this has an easy answer, but I have a main report with the headings in
the page header, the details in the detail section, and the sum of items in
the detail section in the report footer (it's a grand total). Also in the
footer I want to create several subreports but each page header shows up on
pages with these subreports. If I set the page header not to be with footer
my totals for the main report are grouped with the unrelated subreports in
the footer.

Anyway to reassign this page header -- where are we supposed to put the
headings? By default, access sticks them in the Page headers. Or is there
another solution.
Thanks
Frank

 

[Marshall Barton]

I hope this has an easy answer, but I have a main report with the headings in
the page header, the details in the detail section, and the sum of items in
the detail section in the report footer (it's a grand total). Also in the
footer I want to create several subreports but each page header shows up on
pages with these subreports. If I set the page header not to be with footer
my totals for the main report are grouped with the unrelated subreports in
the footer.

Anyway to reassign this page header -- where are we supposed to put the
headings? By default, access sticks them in the Page headers. Or is there
another solution.

The page header is the standard place for column lables. I
think you are asking how to suppress the page header for the
subreports, but keep it for the total text boxes in the
report footer.

If that's the goal, then use a line of code in the report
footer section's Format event procedure:
Me.Section(4).Visible = False
This will hide the page header for all pages *after* the
start of the report footer.

If you want to force the subreports onto a separate page
from the totals, place a PageBreak control just above the
first subreport.