Is there any way to force a page header on a sub-report to display in the main report? -- RJF
"RJF" wrote in message news:439514B9-EC8A-4A31-B674-2F8529009D94@microsoft.com... > 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. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org.
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 wrote: > Is there any way to force a page header on a sub-report to display in the > main report? > >
Hi Allen, That's awesome. You are a genius in my book! Thank you so much. -- RJF "Allen Browne" wrote: > "RJF" wrote in message > news:439514B9-EC8A-4A31-B674-2F8529009D94@microsoft.com... > > 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. > > -- > Allen Browne - Microsoft MVP. Perth, Western Australia > Tips for Access users - http://allenbrowne.com/tips.html > Reply to group, rather than allenbrowne at mvps dot org. >
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. -- RJF "John Spencer" wrote: > 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 wrote: > > Is there any way to force a page header on a sub-report to display in the > > main report? > > > > >
