Suppressing data on ReportFooter pages (A97)

Topic

New Reply

I have a report that produces a multi-page report footer. I have information in the PageHeader section of the detail pages that I want to suppress from the ReportFooter pages. I can’t use If Me.Page = Me.Pages because there are more than one page.

I’ve tried adding coding to the OnFormat event of the ReportFooter section to make the information that I want to suppress invisible, but if I jump to the last page of the report, then walk the pages backwards, it makes the information invisible on detail pages as well.

I’ve also tried adding coding to the OnFormat event of the ReportFooter section to ALWAYS make the information Visible=False and adding coding to the OnFormat event of the PageHeader section to ALWAYS make the information Visible=True. This fixes the above problem, but leaves the information visible on the first ReportFooter page!

Does anyone know of a way to identify that you are about to print the PageHeader for a ReportFooter page? Then I could use this in an IF…Then…Else to make the information either Visible=True or Visible=False.

Reply | Quote

Replies

Have you tried simply setting the page header to not print with the report footer?

Reply | Quote

As a last resort I could do that, but there is SOME information on the page header that I’d like to have printed on each ReportFooter page. I could include the information at the top of the ReportFooter section, but it would only print for the first ReportFooter page.

Thanks for the suggestion.

Reply | Quote