Can I suppress page header in report footer

G

Guest

Hi

I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.

Thanks

Sheila
 
F

fredg

Hi

I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.

Thanks

Sheila
Click to expand...

Reports have a PageHeader property (it's on the Report Property
sheet's Format Tab.
Set it to Not with Rpt Ftr
 
M

Marshall Barton

Sheila said:
I have a report which itemises product sold. On the last page (report
footer) I have a report summary which totals various groups designed for a
top level management report as they have no interest in detail.

What I need to do is suppress the page header in the report footer as it
bears no relation the the layout of the page. I'm sure I saw something about
this a few months ago but can't find it now so any help would be appreciated.
Click to expand...


Add a line of code to the page header's Format event
procedure:
Cancel = (Me.Page = Me.Pages)

If you don't already have one, add a text box (anywhere)
that references the Pages property. A common way is to use:
=Page & " of " & Pages
 
M

Marshall Barton

fredg said:
Reports have a PageHeader property (it's on the Report Property
sheet's Format Tab.
Set it to Not with Rpt Ftr
Click to expand...


Muuuch nicer that my answer, Fred.

I guess I'm stuck on the older way of doing things :-(
 

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

Similar Threads

A03 - count in report footer gives me #Error? 0
"Continued" in Header and Repeat Footers 1
How to suppress last page blank 2
page header on second page of invoice. 3
Need to print Cover Sheet for report. 11
Report - Don't print the page footer on the last page 6
Header and/or footer should be suppressed 3
Report Footer 4

Top