Page between Report Header & Page Header?

G

Guest

Each recipient of my report sees only the information of interest to them.
My report is grouped by [MchStfIDCode], the page header reflects the
recipient, the page footer starts recounting pages at 1, and so on.

The report has a cover memo. I can selectively run the report for an
individual staff member, in which case the cover memo works perfectly (thanks
to good advice in this NG!) when placed in the Report Header.

But I also would like to run all the reports at once, meaning the cover memo
needs to appear BEFORE the first page header at each change in [MchStfIDCode].

I know somebody must have solved this problem. How is it done?

Thanks!
 
G

Guest

I found a way to do it, and it is surprisingly straightforward. Don't use
either the standard ReportHeader or PageHeader. Instead,

1) create a grouping on [MchStfIDCode], show the header but not the footer,
make it non-repeating, and place the memo in that, and

2) create a grouping under that one, based on some item in the data that is
associated with [MchStfIDCode] and which, thus, repeats on every page; show
the header, place the page header controls in that, and make it repeating.
It becomes a faux page header. You can place page footer controls in this
group's footer or in the standard page footer.

There, I paid back a little of what I've learned here!

Have a great weekend.
 
M

Marshall Barton

LongWayFromHome said:
I found a way to do it, and it is surprisingly straightforward. Don't use
either the standard ReportHeader or PageHeader. Instead,

1) create a grouping on [MchStfIDCode], show the header but not the footer,
make it non-repeating, and place the memo in that, and

2) create a grouping under that one, based on some item in the data that is
associated with [MchStfIDCode] and which, thus, repeats on every page; show
the header, place the page header controls in that, and make it repeating.
It becomes a faux page header. You can place page footer controls in this
group's footer or in the standard page footer.

There, I paid back a little of what I've learned here!

Have a great weekend.


Nicely done!

I was trying to think about this, but hadn't got ot the
trick of using two group headers. Logged for future
reference.

Thanks for posting the final resolution of your question.
 

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