Excel Export Into Tabs

[Eddy78]

Is there a way to set up the download of a report to fall into Tabs in Excel. I have 3 data sources for 3 different but all in one.
I would like to set it up such that when It's downloaded the 3 reports each will show up in Excel Tab

[Lech Kulikowski]

Hello,

You can use the ExcelSheet property of the page.

Thank you.

[Eddy78]

Thanks for pointing me in this direction. However, I have done the same and this only works for one column in one DataSource. As per my screenshot below I have 3 datasources And I want all three reports to run at the same time and then download each report in one Excel File but each on it's own Tab.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

[Eddy78]

I have managed to get it to work. Before I was adding all the Reports on one page. I broke them out into 3 pages and then on the Export Excel Sheet Properties I gave each page the {DatasourceName} and on the Save to Excel I selected All bands and selected the "Use One Page Header and Footer"

[Lech Kulikowski]

Hello,

Thank you for the information.