SAP Knowledge Base Article - Public

1217953 - Conditionally suppressed section are not suppressed when exporting to CSV format from Crystal Reports

Symptom

  • Blank lines appears in the CSV file.
  • Conditionally suppressed section doesn't work when exporting to CSV from Crystal Reports.
  • When exporting a report to CSV format that have a conditional suppression applied to the details section, the conditional suppression is ignored causing the conditionally suppressed section to reserve lines in the CSV file.

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, create a report off any data source.
  2. Create a conditional suppression for the details section.
  3. Export the report to CSV format.
  4. When opening the report, notice the conditionally suppressed section reserved lines in the CSV file generated.

Cause

  • Conditional Suppression of section is unfortunately not supported when exporting to Comma Separated Values format (CSV) from Crystal Reports.

Resolution

  • To workaround this limitation, use one of the following suggestions:
      
    • Export the report to MS Excel format then save it as a CSV file; or
           
    • Add the condition(s) used for the conditional suppression of the section in the Record Selection instead when possible. 
      ( This will eliminate the data from coming on the report in the first place. It is not always possible to use this suggestion,
      as it depends on your conditional suppression evaluation time. )
         
  • An enhancement was proposed to have the conditional suppression respected when exporting to CSV format. If you will like to see this functionality added in a future version of Crystal Reports, you can vote for the enhancement at SAP Idea Place by clicking here. Note that this does not guarantee this functionality will be added in the future, but the enhancement proposed on the SAP Idea Place will be reviewed by Product Manager, and the one that receives the most votes have more chance to be looked into in the future.  

Keywords

EXPORT LIMITATIONS CSV CONDITIONAL SUPPRESS DETAILS Crystal Reports Export CSV Format section , c2016241 Enhancement Request ADAPT00721865, ADAPT01323505 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016