2420363 - Unable to export Graph / Chart / Diagram to excel output file while BIRT template is associated to Ad Hoc Report

SAP Knowledge Base Article - Public

2420363 - Unable to export Graph / Chart / Diagram to excel output file while BIRT template is associated to Ad Hoc Report

Symptom

  • Unable to export Graph/ Chart / Diagram to excel output file while BIRT template is associated to Ad Hoc Report
  • Ad Hoc Report: Graph Export
  • Is it possible to export Ad Hoc Report Graph/ Diagrams/ Charts to Excel file?

Environment

 

  • Ad Hoc Report
  • BIRT Template
  • Export to Excel

Reproducing the Issue

  1. Home > Analytics > Reporting > Ad Hoc Report (BIRT Template is associated with Ad Hoc Report)
  2. Run the report online 
  3. Once the report is executed, it shows that there are graph
  4. Now click the Excel button to export

 BIRT TEMPLATE 2.png

 

  • Graph is not present in exported excel output file

 

BIRT TEMPLATE 3.png

Resolution

Go To Provisioning > Company Settings > Turn On below Switches under Company Settings:

 

  • Enable MS Office 2010 compatible output for spreadsheet reports
  • Generate Excel 2010 Output for Ad Hoc Reports

  

BIRT TEMPLATE 1.png

 

  

  • Logout from SFSF instance
  • After 5-10 minutes logon back to SFSF instance
  • Go To Ad Hoc Report
  • Run Offline > Export to Excel
  • NOTE - When BIRT Template is associated with Ad Hoc Report, it is recommended to export the report to excel format by running it offline inorder to export the graph successfully to excel (xlsx) file.

 

BIRT Template 4.png

 

 

Keywords

  • Ad Hoc Report Export 
  • Export to Excel
  • Ad Hoc BIRT Template
  • Graph Export 
  • Diagram Export
  • Chart Export
  • Ad Hoc Graph export
  • Graph export to excel
  , KBA , LOD-SF-ANA-BIR , BIRT Reports , Problem

Product

SAP SuccessFactors HCM Core all versions