Page 1 of 1

Excel Export Into Tabs

Posted: Fri Jul 26, 2024 10:14 pm
by 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

Re: Excel Export Into Tabs

Posted: Sun Jul 28, 2024 6:40 pm
by Lech Kulikowski
Hello,

You can use the ExcelSheet property of the page.

Thank you.

Re: Excel Export Into Tabs

Posted: Tue Jul 30, 2024 3:50 pm
by 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.

Re: Excel Export Into Tabs

Posted: Tue Jul 30, 2024 7:39 pm
by Lech Kulikowski
Hello,

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

Thank you.

Re: Excel Export Into Tabs

Posted: Tue Jul 30, 2024 8:14 pm
by 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"

Re: Excel Export Into Tabs

Posted: Wed Jul 31, 2024 9:27 am
by Lech Kulikowski
Hello,

Thank you for the information.