SAP Knowledge Base Article - Public

2842708 - Canvas / ORD export to CSV returns no data

Symptom

When certain Canvas / ORD reports are exported to CSV, the file only has the column headers

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Online Report Designer / Report - Canvas: Advanced reporting

Reproducing the Issue

Run the affected report(s) via Background Export or Report Distributor (offline, Email) in CSV format.
The exported file has only the column headers.

Cause

Column grouping applied to the report (through 'Edit Formatting').
CSV file formats do not support merged cells.

newResol.png

Resolution

Without modifying the report:

  • Grouped / merged cells cannot be exported in CSV file import.
  • Hence the report will HAVE to be exported in XSL/XSLX file formats.

By modifying the report:

  • If the export HAS to be in CSV file format, it can be done so by removing the grouping applied.
  1. Edit the report.
  2. Select the component under concern and click 'Edit Formatting'
  3. Press left top corner to select all.
  4. Right click the previously column and choose 'ungroup selected columns'

 

Keywords

CSV, column, headers, title, data, missing, only, ORD, Canvas, Report, Center, Advanced, Detailed, Reporting, xls, group, by , grouping , KBA , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Suite all versions