SAP Knowledge Base Article - Public

2850967 - Scheduling Canvas Reports via Report Distributor to Export with XLSX Format

Symptom

This KBA explains how to distribute Canvas reports via Legacy Report Distributor in XLSX format through Run Offline/to SFTP.

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 HXM Suite

Reproducing the Issue

  1. Access the legacy Report Distributor tool from Report Center > View Schedules > Switch to Legacy Report Distributor
  2. Add a report that is an Excel export of the Report Designer component.
  3. Schedule the bundle to run offline/to SFTP.

Cause

The report components added to the bundle should be in MS Excel format as there are some components that can be added as CSV.

Resolution

To distribute reports via Legacy Report Distributor in XLSX format, please try either of the following:

A. After creating the bundle, select File > Edit > Excel File Format - change this to xlsx


B. Click Run Report Distributor. Users can choose XLS/XLSX, as per the below screen shot:

2850967.PNG

See Also

KB article 2317668 - What is the SuccessFactors Report Distributor?

Keywords

sf, success factors, ANA, WFA, ORD, rpt, XLS, schedule, destination, centre, center, XLSX, SFTP, Run Offline, Canvas export, Canvas schedule , KBA , LOD-SF-ANA-RDT , Report Distributor (Advanced Reporting, ORD) , How To

Product

SAP SuccessFactors Workforce Analytics all versions