Page Header

  • Thread starter Thread starter Ellen
  • Start date Start date
E

Ellen

Hello,
I have created a report of a simple table (3 columns, 100
rows) using the defaults. It looks quite nice, except
that it places the column headers in the page header
section.

I'd like to modify this report so that it looks the same,
but allows me to place the name of the report in the page
header section. This way if the pages get separated, one
can easily figure out what report they came from .

Can someone help me?

Thank you in advance,
Ellen
 
Thanks, Allen. Is there anyway to prevent the table
header from appearing above the lengthy report footer that
I neglected to mention?
-----Original Message-----
Try a text box with Control Source of:
=[Report].[Name]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hello,
I have created a report of a simple table (3 columns, 100
rows) using the defaults. It looks quite nice, except
that it places the column headers in the page header
section.

I'd like to modify this report so that it looks the same,
but allows me to place the name of the report in the page
header section. This way if the pages get separated, one
can easily figure out what report they came from .

Can someone help me?

Thank you in advance,
Ellen
Click to expand...


.
Click to expand...
 
Assuming the report footer fits onto the last page, try:
=IIf([Page] = [Pages], Null, [Report].[Name])
 
Back
Top