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.
SAP SuccessFactors HXM Suite
Reproducing the Issue
- Access the legacy Report Distributor tool from Report Center > View Schedules > Switch to Legacy Report Distributor
- Add a report that is an Excel export of the Report Designer component.
- Schedule the bundle to run offline/to SFTP.
The report components added to the bundle should be in MS Excel format as there are some components that can be added as CSV.
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:
KB article 2317668 - What is the SuccessFactors Report Distributor?
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