Export Bex Chart to Excel
In my WAD template, I have created two buttons to enable me to toggle between displaying a 'table' or 'chart'. I also have a button to Export to Excel. Exporting to Excel works fine when the table is visible, however when I toggle to display the chart and then click on export to excel, the chart is not being exported, the excel file is blank.
The export button has these commands:
Command = EXPORT
Export format = XLS
Web Item = Default
Show Export Dialogue = On
Are you able to advise as to which settings are required to enable exporting to excel when a chart is being displayed?
I tried changing the Web Item to have two parameters, ANALYSIS and CHART_ITEM_1, however this did not appear to work for me.
I have the answer. Within the Export to Excel button parameters, using Command=EXPORT, I set the Web Template to the same named template as I'm using. Previously, it was set to a SAP Standard template called 0ANALYSIS_PATTERN_EXPORT, I've changed this to my Z* web template name and now exporting both the table and chart works fine.
The very best to you,