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