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
- In Crystal Reports, create a report on any data source.
- In the details section, Add 2 rows of data.
- 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:
- kba: 1946358 - Crystal Reports features supported by exporting format - SAP for Me
- kba: 2553150 - How to submit enhancement requests for SAP BusinessObjects BI Platform? - SAP for Me
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