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

SAP Knowledge Base Article - Public

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

Symptom

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.

Environment

SAP SuccessFactors Online Report Designer

Cause

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.

Resolution

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.

Keywords

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

Product

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