SAP Knowledge Base Article - Public

2231556 - Blank rows added to the spreadsheet, when exporting a report that contains a subreport to MS Excel from Crystal Reports

Symptom

  • Blank rows in Excel.
  • Empty rows added in MS Excel, for some reports.
  • Extra blank row is added in the exported .xls file when exporting a report which contains a subreport that has multiple pages, from Crystal Reports to MS Excel format.

Environment

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

Reproducing the Issue

  1. In Crystal Reports designer, create a report off any data source.
  2. Insert one subreport and make it contains lots of details rows to make it display on multiple pages.
  3. Export the report to Microsoft Excel (97-2003) Data-Only or Microsoft Excel (97-2003) format.
  4. In MS Excel, open the exported file, and notice there are blank rows where the subreport is located in Crystal Reports.

Cause

  • This is a limitation of the MS Excel exporting driver.

Resolution

  • Depending on how the report is designed, it may be possible to workaround this limitation by performing one of the following:
    • In Crystal Reports, modify the report design to insert the subreport data in the main report; or
    • In MS Excel, use the EXCEL function to delete blank rows automatically.

See Also

  • For a list of Crystal Reports supported functionalities by exporting format, see the SAP Knowledge Base Article 1946358

Keywords

rpt, empty, xls, format, space, excel, export, blank, extra , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

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