Subreport Headers

I have a subreport which contains headers. How do I have the subreport
headers show up when placed in the main report?

It need to be placed on the Report Header of the sub report, the page header
of the sub report will disapear.

--
\\// Live Long and Prosper \\//
BS"D


"Arun" wrote:

I have a subreport which contains headers. How do I have the subreport
headers show up when placed in the main report?

Arun wrote:

I have a subreport which contains headers. How do I have the subreport
headers show up when placed in the main report?


All headers in the subreport should work, except the page
header/footer. So I think you must mean that you want to
simulate the subreport page header.

This is done by creating a top level group with header in
the subreport. Set the group Field/Expression to a constant
expression such as =1 or ="Funky Page Header". Then move
all the controls from the inefffective page header to the
new group header and set to group header's RepeatSection
property to Yes.

--
Marsh
MVP [MS Access]

Okay great, that works.

Now, how do I get the subreport headers to appear on every page of the main
report? For example, the subreport items roll into the second page and where
I don't have any headers.

Create a new top level sorting and grouping level based on a constant like
=1
Display the header section for this grouping and set the Repeat Section
property of the header section to Yes. Use this section as a "Page" header.

--
Duane Hookom
MS Access MVP
--

"Arun" wrote in message
...
Okay great, that works.

Now, how do I get the subreport headers to appear on every page of the
main
report? For example, the subreport items roll into the second page and
where
I don't have any headers.

I'm sorry I'm not a very technical person. Could someone kind of dumb this
down for me. Thanks

"Duane Hookom" wrote:

Create a new top level sorting and grouping level based on a constant like
=1
Display the header section for this grouping and set the Repeat Section
property of the header section to Yes. Use this section as a "Page" header.

--
Duane Hookom
MS Access MVP
--

"Arun" wrote in message
...
Okay great, that works.

Now, how do I get the subreport headers to appear on every page of the
main
report? For example, the subreport items roll into the second page and
where
I don't have any headers.

Open your report's sorting and grouping dialog. Create a new level based on
the Field/Expression of:
=1
Make sure this is the first sorting and grouping level. In the sorting and
grouping dialog set this level to display the group header.

View the properties of the new =1 group header section. Find the Repeat
Section property and set it to Yes. This =1 group header section can be used
as a page header for your subreport.

--
Duane Hookom
MS Access MVP

"JosephDisney" wrote in message
...
I'm sorry I'm not a very technical person. Could someone kind of dumb
this
down for me. Thanks

"Duane Hookom" wrote:

Create a new top level sorting and grouping level based on a constant
like
=1
Display the header section for this grouping and set the Repeat Section
property of the header section to Yes. Use this section as a "Page"
header.

--
Duane Hookom
MS Access MVP
--

"Arun" wrote in message
...
Okay great, that works.

Now, how do I get the subreport headers to appear on every page of the
main
report? For example, the subreport items roll into the second page and
where
I don't have any headers.

I found this answer very helpful, but how can I get a different header for
the first and second pages of a subreport?


"Marshall Barton" wrote:

Arun wrote:

I have a subreport which contains headers. How do I have the subreport
headers show up when placed in the main report?


All headers in the subreport should work, except the page
header/footer. So I think you must mean that you want to
simulate the subreport page header.

This is done by creating a top level group with header in
the subreport. Set the group Field/Expression to a constant
expression such as =1 or ="Funky Page Header". Then move
all the controls from the inefffective page header to the
new group header and set to group header's RepeatSection
property to Yes.

--
Marsh
MVP [MS Access]