Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Suppressing data on ReportFooter pages (A97)

    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 <font color=448800>If Me.Page = Me.Pages</font color=448800> 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.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Suppressing data on ReportFooter pages (A97)

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

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Suppressing data on ReportFooter pages (A97)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •