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.