subreports - no page headers?

B

_Bigred

I have created a Report with 4 different subreports on it.


Each Subreports

Report Headers - Display properly
Page Header - not displayed
Detail - Display properly

* How do I get the Page Headers to show in these subreports?

TIA,
_Bigred




I'm protected by SpamBrave
http://www.spambrave.com/
 
A

Allen Browne

That's correct. By design, the main report's page header/footer is printed
on the page, not the subreport's PageHeader/footer.

You can simulate a page header in a subreport with a group header that
repeats:
1. In the subreport's Sorting And Grouping dialog, choose a suitable field,
and set Group Header to Yes. Access adds a new section to the report.

2. Right-click the new section, and choose Properites.
Set the Repeat Section property to Yes.

If you don't have a suitable field, add a new field to the subreport's
query, such as:
AlwaysFalse: False
This field will be 0 for all records, so the group header will appear at the
top of every page in the subreport.
 
B

_Bigred

THANKS ALLEN that hit it right on the head..

much thanks,
_Bigred


Allen Browne said:
That's correct. By design, the main report's page header/footer is
printed on the page, not the subreport's PageHeader/footer.

You can simulate a page header in a subreport with a group header that
repeats:
1. In the subreport's Sorting And Grouping dialog, choose a suitable
field, and set Group Header to Yes. Access adds a new section to the
report.

2. Right-click the new section, and choose Properites.
Set the Repeat Section property to Yes.

If you don't have a suitable field, add a new field to the subreport's
query, such as:
AlwaysFalse: False
This field will be 0 for all records, so the group header will appear at
the top of every page in the subreport.



I'm protected by SpamBrave
http://www.spambrave.com/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top