I have a chart and and a list for a report. Is it possible for pagebreak chart on tab1 and then the list on tab2 when exported to excel format? But it is required that they appear on the same page in HTML, for which I will use ReportOutput variable, but I am trying to see how can I split Chart and List into two different tabs in excel.
Thank you very much for your help!
1.create two more pages. Set a render variable to them so that they'll only render if output is excel.
2.set a render variable to your first page to not render for excel.
3.drag a layout reference object and bring in the list two your second page. Do the same with the chart on your third.
That's it. Different pages will render as different tabs in excel.
Thanks so much! Such simple solution.