By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 2,015 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Printing Page Heaer of a sub report

P: n/a


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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.