SAP Knowledge Base Article - Public

3279431 - Custom BIRT report error when exporting to Excel

Symptom

When exporting a Report Custom (with BIRT template), the resulting Excel file cannot be opened and shows the message "Excel cannot open the file because the file format or file extension is not valid".

Environment

  • SAP SuccessFactors HXM Suite
    • Analytics & Reporting (Ad Hoc, YouCalc, ORD)
      • Table Reporting

Reproducing the Issue

1. Login and go to Reporting
2. Run Custom BIRT report 
3. You will get the guardrails message so export it Offline

  • Run Offline, choose Excel and download from Scheduled Reports

4. Download the file
5. Open the Excel
Result: Error (Excel cannot open the file because the file format or file extension is not valid)

6. Try exporting it again but this time choose .CSV format
Result: CSV format is OK.

Cause


BIRT 2.6 is not compatible with JDK11 which is a universal upgrade across all of Bizx server types.

Resolution

 Customers would need to upgrade to 4.3 if not yet upgraded.

Keywords

AdHoc, Table report, download, export, XLS, XLSX, Microsoft Excel 2007 format, MS Excel, Excel, Error, Custom, BIRT, file extension, not valid, Format , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-BIR , BIRT Reports , Problem

Product

SAP SuccessFactors HXM Suite 2211