Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 20 Sep 2019 09:50:00 AM

Title: Cognos 11 Report setup - split report into multiple Excel tabs/sheets
Post by: peewan on 20 Sep 2019 09:50:00 AM
is it possible to split the Report into multiple Excel tabs by Client# or Group#?
I have to run the run the report for 121 Clients, and they one each CLient in different excel sheet/tab.

Thank you helping!
Title: Re: Cognos 11 Report setup - split report into multiple Excel tabs/sheets
Post by: dougp on 20 Sep 2019 10:17:12 AM
In the Cognos report, that would be pages.  Try using a page set.
Title: Re: Cognos 11 Report setup - split report into multiple Excel tabs/sheets
Post by: sreddy on 23 Sep 2019 01:23:45 PM
Hi Peewan,

You can try Cognos Bursting feature.

Thanks!!
Title: Re: Cognos 11 Report setup - split report into multiple Excel tabs/sheets
Post by: peewan on 03 Oct 2019 11:53:19 AM
Quote from: dougp on 20 Sep 2019 10:17:12 AM
In the Cognos report, that would be pages.  Try using a page set.

Page set works perfect for me! Thank you! :)
Text only | Text with Images