SAP Knowledge Base Article - Public

1181875 - A subreport object causes blank lines in Excel Data Only Export

Symptom

  • Exporting a report which contains a sub report to Excel (Data only) format inserts blank lines before and after the sub report object.
  • In addition, if the sub report contains suppressed objects, an additional blank line is introduced.

Environment

Crystal Reports 2008

Cause

  • This behavior is by design.
  • The exporter introduces one line each before and after the object and one additional blank line for the sub report that contains suppressed objects.

Resolution

  • You cannot remove the blank lines before and after the subreport object; however if the subreport does not contain any suppressed objects, the third blank line may be avoided.

Keywords

subreport;excel; export; blank lines; , 1506828 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2