Page Headers in Subreports

[RJF]

Is there any way to force a page header on a sub-report to display in the
main report?

 

[Allen Browne]

Is there any way to force a page header on a sub-report to display
in the main report?

You can simulate it with a repeating group header.

1. Open the subreport in design view.

2. Open the Sorting And Grouping box (View menu.)

3. As the top row, insert an expression that won't change, e.g.:
=0

4. Below this, set Group Header to Yes.
Access adds a new group header to the report.

5. Select the new group header, and set its Repeat Section property to Yes.

The new section now repeats at the top of each page.

 

[John Spencer]

No page headers and footers are controlled by the main report.

What you can do is
-- add a top-level group to the sub-report
-- set the field to =1 (or any constant)
-- close the Sorting and grouping dialog
-- Copy the Page header controls into the group
-- Set the Group's Repeat Section property to True (Yes)


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[RJF]

Hi Allen,

That's awesome. You are a genius in my book!

Thank you so much.

 

[RJF]

Hi John,

Another genius! That was the same answer I got from Allen and it works great.

Thank you very much and also thank you for your quick response.