Symptom
1. Trying to generate Table reports in XLS or XSLX format.
Environment
- SAP SuccessFactors HXM Suite
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Table Reporting
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
- Login to instance
- Navigate to Report Center
- Select any Ad Hoc report and Run it.
- Export the Ad Hoc report's output:
- Run Online and Export or
- Run Offline, choose Excel and download from Scheduled Reports
- Run Online and Export or
- The downloaded file is in '.xls' or '.xslx' format
Cause
Generated excel format of table report depends on the toggle configuration.
Resolution
Please create a Case with Reporting and Analytics Support team requesting to enable the below configuration via service request.
- Please turn off the AYT_ReportBuilder_MSOffice2010_1601578369 (If you had to generate in XLS Format)
- Please turn on the AYT_ReportBuilder_MSOffice2010_1601578369 (If you had to generate in XLSX Format)
See Also
Keywords
AdHoc, Table report, download, export, XLS, XLSX, Microsoft Excel 2007 format, MS Excel
Product
SAP SuccessFactors HXM Suite 2211