SAP Knowledge Base Article - Public

1212056 - Unwanted page breaks or blank page appears before the subreport in Crystal Reports

Symptom

  • Blank page.
  • First page of a report is empty.
  • In Crystal Reports, when previewing a report that contains subreport, it add unwanted page break before the subreport.

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 a subreport on the report.
  3. When previewing the report, the first page of the report is blank, or there is unwanted page breaks before the subreport.

Cause

  • A blank page, or a page break is created because by default a section is formatted with the option 'Keep Together'.  When this option is checked, and if there is no enough space on the page to print the whole subreport, it will avoid breaking the subreport by generating a page break, and start printing the subreport on a new page.

Resolution

  • Uncheck the option: "Keep Together" for the sections in which the subreport is located, as well as the subreport option "Keep Object Together":
      •   
    1. In Crystal Reports, open the report.
               
    2. Uncheck the option "Keep Together" for the section in which the subreport is located:
      1. Under the menu "Report", select "Section Expert..."
      2. In the "Section Expert" window, select the section in which the subreport is located. ( For example: Report Header, Details,... )
      3. On the right side, uncheck the option "Keep Together"
      4. Click "OK" to accept the change.
              
    3. Uncheck the subreport option: "Keep Object Together"
      1. Right click on the subreport, and select 'Format Subreport...
      2. In the 'Format Editor', under the tab 'Common', uncheck the option "Keep Object Together"
      3. Click "OK"
             
    4. If your report contains Groups, and your subreport is located within a group, then uncheck 'Keep Together' for the group in the main report and subreport by completing the following steps
      1. Under the menu "Report", select "Group Expert..."
      2. In the "Group Expert" window, select the "Group", and click the button "Options..."
      3. In the "Change Group Options" window, under the tab "Options", uncheck the option "Keep Group Together"
      4. Click "OK"
      5. If you have multiple groups, you may have to change the group options for the other groups as well, then click "OK" to accept the change.
                 
    5. Preview the report, and there should not have any blank page, or white gap before the subreport start displaying. 
           
      If there is still a blank page before the subreport, then it is the sections whithin the subreport that are causing the extra blank page. Then ensure you uncheck the section options "Keep Together" within the subreport.
      1. Under the tab "Design", right click on the subreport, and select "Edit Subreport"
      2. Now, in the subreport design, uncheck the section option "Keep Together"
      3. If you have groups. uncheck the group option "Keep Object Together"

Keywords

SUBREPORT PAGE BREAK FLOW PAGES SECTIONS Seagate Crystal Reports Formatting Subreport Page Break , c2006949 , 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