SAP Knowledge Base Article - Public

2666825 - How to remove blank lines from crosstab report exported to MS Excel

Symptom

  • How to remove blank lines

Environment

  •  SAP Crystal Reports 2016

Reproducing the Issue

  1. Create a new report with Crosstab in Group Header.
  2. Suppress all other sections
  3. Refresh the report
  4. Export the report to MS Excel
  5. There are empty rows between the groups

Cause

  • Section Break is causing an empty row

Resolution

  • If possible, move the report Grouping inside the Crosstab
  • Then move the Crosstab to the Report Header

See Also

1841430

Keywords

empty, blanc, rows, lines , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2016