468,283 Members | 1,911 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,283 developers. It's quick & easy.

Printing Page Heaer of a sub report



Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.

Thanks for any help.

Kind regards,

Simon
Dec 11 '07 #1
2 2577
Simon wrote:
Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.
I'm sure others have some methods different than mine. The report
header only prints once in a subform. Page headers/footers not at all.
My method also works great when you want to print a multicolumn reports.

First, I go into the Recordsource of the report and if not a query, make
it one by clicking on the triple-dot. I then add a column. I call it
Master. To create this column in the query builder I enter
Master : "M"

Save the recordsource. Now every record will have a column called
Master. I now go to Sorting&Grouping in the Reports menu. I now add a
new sort field, Master, drag it to the top of the sort list usually, and
create a header and if need be a footer.

You'll now see a band for Master. Double click on the band to pull up
it's property sheet. Under the Format tab look for RepeatSection. Set
it to Yes if you anticipate the subreport may print on multiple pages.

Now move your Page/Footer header stuff into Master's respective bands.

That's it.

Hick
http://www.youtube.com/watch?v=XJMJmiRqR60
>
Thanks for any help.

Kind regards,

Simon

Dec 11 '07 #2
On Tue, 11 Dec 2007 21:37:34 +0100, "Simon" <Sv********@Versatel.nlwrote:
>

Dear reader,

In case a report is a sub report the Report Header of the sub report is
printed in the report but the Page Header of the sub report will not be
printed. This is the same for Page Footer of the sub report.

Is there a possibility to force printing Page Header and Page Footer of a
sub report.

The Page Header and Footer of the master report is not the problem it is the
sub report.

Thanks for any help.

Kind regards,

Simon
You can use a Group Header/Footer instead of the Page Header/Footer.

In the recordsource of the subreport include a calculated field which returns a
common value for every record. eg PgHead:0
This ensures every record in the recordsource is included under a single group.

In the design of the subreport add a Group Header/Footer for the field PgHead.
Cut all the controls out of your Page Header/Footer and paste them into the
Group Header/Footer.
Set the Repeat Section property of the Group Header to True.
Remove the Page Header/Footer.

The Group Header/Footer should display in the subreport as a Page Header/Footer
would normally display.


Wayne Gillespie
Gosford NSW Australia
Dec 11 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Lucas Ponzo | last post: by
2 posts views Thread by Brad Pears | last post: by
18 posts views Thread by Brett | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
2 posts views Thread by MrBee | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.