Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Show Report Header and Footer nn first page only 1

Status
Not open for further replies.

TimTDP

Technical User
Feb 15, 2004
373
ZA
How do I show a report header and footer only on the first page of a report?
The header must be at the top of the page and the footer at the bottom of the page, regardless of the content of the report.
 
I am sure Report header will show only in the first page.

Now for the footer. Create a page footer (I repeat a PAGE FOOTER) and hide it after the first page
Code:
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = Page > 1
End Sub
or a select case where you show/hide
Code:
Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
Select Case Page
Case 1
    Cancel = True
Case 3
    Cancel = True
End Select
End Sub

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top