SAP Knowledge Base Article - Public

1207880 - How to suppress the Page Header of the last page of the report in Crystal Reports?

Symptom

  • Page Header prints on the last page.
  • In Crystal Reports, how to not print the Page Header on the last page of the report?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020 

Reproducing the Issue

  1. In Crystal Reports, create a report based on any data source.
  2. Insert database fields in the Details section.
  3. Insert text in the Page Header section.
  4. Insert text or fields in the Report Footer section.
  5. When refreshing the report, notice the Page Header prints on the last page of the report where the Report Footer also print.
    How to not print the Page Header on the last page? 

Resolution

  • Conditionally suppress the Page Header when the Page Number equal to the Total Number of Page of the report by using the special function: PageNumber, and TotalPageCount
        
    1. In Crystal Reports, open the report.
         
    2. Under the menu "Report", select "Section Expert"
        
    3. In the "Section Expert" window, select the Page Header section.
        
    4. On the ride side, under the tab "Common", for the option "Suppress (No Drill-Down)", click on the "X-2" button.
         
    5. In the Formula Editor, type the following formula:
       
        PageNumber = TotalPageCount

    6. Click on "Save and close"
        
    7. Back to "Section Expert", click on "OK"

Keywords

PAGE HEADER SUPPRESSION LAST PAGE DETAIL RECORD TOTALPAGECOUNT Seagate Crystal Reports Suppressing page headers TotalPageCount , c2000595 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020