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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.