Hi,
When I run the report as excel, the following are happening
1. Empty chart component is created in each master/detail sheet
2. All hidden sheets containing data for each chart are created correctly
The problem is the chart in each master/detail sheet is not mapped to its corresponding hidden sheet. One of the manual ways to fix this after excel creation is to unhide all chart data sheets and map the data to each chart.
Please let me know if anyone has faced this problem and a possible way to fix this.
Note: Running the output as HTML / PDF works fine.
Thanks in advance.