SAP Knowledge Base Article - Public

1208909 - Removing blank pages and large blank spaces in a report in Crystal Reports

Symptom

  • Blank first page.
  • When viewing a report in Crystal Reports, extra blank pages or large blank space appear on the report.
  • How to remove blank pages on a report in Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Add groups, subreports, multiple sections, ... to the report.
  3. When viewing the report, the first page of the report is blank, or there is large blank spaces on the report.

Cause

  • This situation occurs due to how the report sections and object has been formatted.
  • Common formatting options that inadvertently cause extra blank pages or large blank space to appear in a report are:
    • New Page After
    • New Page Before
    • Keep Section Together
    • Keep Object Together
    • Keep Group Together
    • Print At Bottom of Page

Resolution

  • Below are the most common scenarios with the solution on how to remove blank pages or large blank space from a report.
    Refer to the solution based on the scenario that best describes what appears on your report.
         
                 
  • First Page Blank
    The report displays a blank page in the Report Header ahead of displaying the report data.       

    • Cause
      The conditions that cause the blank page in the Report Header to occur are:
      • The first group level is formatted with Keep Group Together.
      • The first group displays more records than there is space available on the first page.
                
    • Solution
      To prevent a blank page in the Report Header from appearing, follow these steps:
      1. From the "Report" menu, select "Group Expert"
      2. In the "Change Group Expert" dialog box, select the first group and click the Options button.
      3. Under the tab "Options", uncheck the option "Keep Group Together"
      4. If there are multiple group levels, you may need to repeat steps 1 to 3.
               
        Upon previewing the report, the first group will appear immediately and the blank page in the Report Header will be removed.
                               
             
  • First Page Blank ( Second Scenario)
    Although the Keep Group Together option has been unselected for all the group levels as described in scenario one, the report continues to display a blank page in the Report Header ahead of displaying the report data.

    • Cause
      The conditions that cause the blank page to continue to appear are:
      • There is an object such as a subreport , picture, or text object in the report.
      • The object is too large to fit on the first page.
      • The object is formatted with the Keep Together option.
            
    • Solution
      To prevent a blank page from appearing, follow these steps:
      1. In Design view, right-click the object and select Format.<…>. For example: Format Subreport, Format Text Object, Format Graphic
      2. In the Format Editor dialog box, click the Common tab.
      3. Unselect the Keep Object Together check box.
             
        Upon previewing the report, the blank page in the Report Header will be removed.
                    
               
  • Blank page before the first section
    A blank page appears before the first section of the report.
               
    • Cause
      At least one section of the report is formatted with the New Page Before option selected. Therefore, each time this section prints, it starts on a new page.
      Although this is the desired affect for the subsequent sections of the report, a new page should not print before the first instance of this section.
            
    • Solution
      To prevent a blank page from appearing before the first section, follow these
      steps:
      1. From the Format menu, select Section.
      2. In the Section Expert dialog box, select the section with the New Page Before check box enabled.
      3. Click the formula button (X+2) to type in the following conditional formatting formula:
           
        // This conditional formatting formula instructs a new page to print except for the first record.
        Not OnFirstRecord
           
        Upon completing these steps, the report will display each section on a new page except for the first one. This removes the blank page before the first section.
          
                  
  • Blank space after the Report Header
    A blank space appears after the Report Header section. This causes the report data to start printing on the second page.
            
    • Cause
      This occurs when the Report Header section is formatted to have the New Page After check box enabled.
            
    • Solution
      To prevent a blank space from appearing after the Report Header section, follow these steps:
      1. From the Format menu, select Section.
      2. In the Section Expert dialog box, select the Report Header and disable the New Page After check box.
          
        Upon previewing the report, a blank space will not appear after the Report Header section.
           
                      
  • Blank space before a section
    A blank space or page appears before a section of the report.
         
    • Cause
      This occurs if a section is formatted with the Keep Together option enabled and that section contains more records than will fit on the remaining area of a page.
         
    • Solution
      To prevent a blank space from appearing before a section, follow these steps:
      1. From the Format menu, select Section.
      2. In the Section Expert dialog box, select the Report Header and disable the Keep Together check box.
      3. Repeat step 2 for any section with the Keep Together option that causes a blank space from appearing.
             
        Upon previewing the report, a blank space has been removed from appearing before the section.
                       
               
  • Blank spaces appear between sections
    Blank spaces appear between sections of the report.
             
    • Cause
      This occurs when a section is formatted with the Print at Bottom of Page option enabled.
          
    • Solution
      To prevent blank spaces from printing between sections, follow these steps:
      1. From the Format menu, select Section.
      2. In the Section Expert dialog box, disable the Print at Bottom of Page for the section causing the blank space.
      3. Repeat step 2 for any section with the Print at Bottom of Page option that causes a blank space from appearing.
             
        Upon previewing the report, the blank space between sections is removed.
             
        NOTE: If the report contains a subreport, it will be necessary to edit the subreport and check to see if any of the formatting options in the above mentioned scenarios are causing the blank page or space to appear.

Keywords

blank first page Seagate Crystal Reports Seagate Info Blank first page Keep Group Together , c2002092 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016