Sub Reports

Greetings,
I am running Access 2000. I have two reports defined. I read the help
system on putting one of
the reports as a sub report in the other. I did this. So, report B is a
subreport of A. The problem is
that with my dataset report B is only one page in length. At the top of the
printed report page for B, I see the page header for A. I do not see the
page header for B.

How can I make the page header for B show instead of A ?

thanks,
Darryl

Page sections of subreport don't show/display. You can create a pseudo page
header by making a primary sorting and grouping level on a constant
expression like:
=1
Show the =1 header section and set its Repeat Section property to Yes.

Use this new =1 group header as your subreport's page header.

--
Duane Hookom
MS Access MVP


"Darryl" wrote in message
...
Greetings,
I am running Access 2000. I have two reports defined. I read the help
system on putting one of
the reports as a sub report in the other. I did this. So, report B is a
subreport of A. The problem is
that with my dataset report B is only one page in length. At the top of
the
printed report page for B, I see the page header for A. I do not see the
page header for B.

How can I make the page header for B show instead of A ?

thanks,
Darryl

Now I get:
Multi-level group by clause is not allowed in a subquery.

I ran my query standalone and had no errors or problems.

whats up with this error ?

-Darryl

"Duane Hookom" wrote in message
...
Page sections of subreport don't show/display. You can create a pseudo
page
header by making a primary sorting and grouping level on a constant
expression like:
=1
Show the =1 header section and set its Repeat Section property to Yes.

Use this new =1 group header as your subreport's page header.

--
Duane Hookom
MS Access MVP


"Darryl" wrote in message
...
Greetings,
I am running Access 2000. I have two reports defined. I read the help
system on putting one of
the reports as a sub report in the other. I did this. So, report B is
a
subreport of A. The problem is
that with my dataset report B is only one page in length. At the top of
the
printed report page for B, I see the page header for A. I do not see
the
page header for B.

How can I make the page header for B show instead of A ?

thanks,
Darryl

It would help to know:
-the sql view of the record source of your subreport
-the expressions in your subreport Sorting and Grouping

--
Duane Hookom
MS Access MVP
--

"Darryl" wrote in message
...
Now I get:
Multi-level group by clause is not allowed in a subquery.

I ran my query standalone and had no errors or problems.

whats up with this error ?

-Darryl

"Duane Hookom" wrote in message
...
Page sections of subreport don't show/display. You can create a pseudo
page
header by making a primary sorting and grouping level on a constant
expression like:
=1
Show the =1 header section and set its Repeat Section property to Yes.

Use this new =1 group header as your subreport's page header.

--
Duane Hookom
MS Access MVP


"Darryl" wrote in message
...
Greetings,
I am running Access 2000. I have two reports defined. I read the
help
system on putting one of
the reports as a sub report in the other. I did this. So, report B is
a
subreport of A. The problem is
that with my dataset report B is only one page in length. At the top
of
the
printed report page for B, I see the page header for A. I do not see
the
page header for B.

How can I make the page header for B show instead of A ?

thanks,
Darryl