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
- In Crystal Reports designer, create a report off any data source.
- Insert one subreport and make it contains lots of details rows to make it display on multiple pages.
- Export the report to Microsoft Excel (97-2003) Data-Only or Microsoft Excel (97-2003) format.
- 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