SAP Knowledge Base Article - Preview

1451960 - Null or empty values are not surrounded with delimiter when exported to CSV format from Crystal Reports

Symptom

  • Null or empty values are not surrounded by delimiter when exported to CSV format.
  • When exporting a report to CSV format from Crystal Reports, the database fields of type text that contains no data ( empty or NULL ) are not surrounded by the selected delimiter.
         
         
  • Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
      
  • SAP Crystal Reports for Visual Studio 2010

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

Delimiter, CSV, Crystal Reports, CR, NULL, empty string, no value, export , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.