SAP Knowledge Base Article - Public

3378325 - Multiple rows merged into 1 row when exporting crystal report to csv

Symptom

  • Export to csv format of a crystal report containing several rows per record, the rows are merged into a single row per record.
  • No issue exporting to excel or PDF.

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, create a report on any data source.
  2. In the details section, Add 2 rows of data.
  3. Export the report to CSV format.
    >>When opening the CSV document, notice that the 2 rows are merged into 1 row per record.

Cause

By design, Separated values is a record-based data-exchange format.  
One line of values is exported for each record of your report and each record contains all of the fields in each section of your report as seen in the Design view.
 
PDF and Excel are Page-based format and will export both formatting and layout consistent with the report's appearance on the Preview tab.
 

Resolution

This feature is not available in the product, however, it may be raised as an Enhancement Request which can be considered in a future release.

To request a new feature or product enhancement, SAP has defined a new process and tool that is now available to customers called Idea Place: Influence Opportunity Homepage - Customer Influence (sap.com). Idea Place gives customers the ability to log their own Enhancement Requests and work more directly with our Technology and Development group.

See Also

For a list of Crystal Reports supported functionalities by exporting format, please check the below:

 

Keywords

line, line break, fusion, same, sections, empty line , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Product Enhancement

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020