Sub Reports

D

Darryl

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
 
D

Duane Hookom

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.
 
D

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
 
D

Duane Hookom

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