SAP Knowledge Base Article - Public

2382178 - Online Report Designer: Excel Report Export truncated / missing rows


Reports and the query behind a report component can be exported to Excel format in the Online Report Designer. Very large reports, with a lot of rows, can appear truncated once exported to Excel.


SAP SuccessFactors Online Report Designer


If the row count of an export exceeds 65535, exporting to Excel (XLS/XLSX) format due to limitations with the Excel (XLS/XLSX) version. Excel has certain limits on size which ORD cannot override.


The solution is to use the CSV export format available. This is without limitations and will allow for exporting large reports. Bear in mind that large exports should be run through the Report Distributor. You can use the function "Attach to Bundle" directly in the query, or when editing the query behind a report component.


ORD, Realms, Advanced Reporting, Query Download, Report Download, export issue , KBA , LOD-SF-WFA , Workforce Analytics & Planning , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HCM Core 1608 ; SAP SuccessFactors Workforce Analytics all versions