Print Page - Seperate Tabs in Excel Output based on Groups

Title: Seperate Tabs in Excel Output based on Groups
Post by: rpvs on 05 Nov 2009 10:03:04 AM

Hi All,
We have a huge report which is grouped based on product line and would like to have seperate tabs for each product line in excel output. Any ideas on how to do this when outputting report to excel or even bursting report??

Title: Re: Seperate Tabs in Excel Output based on Groups
Post by: Gopinath on 05 Nov 2009 12:32:36 PM

Create a PageSet and and Set the Grouping as Productline

Title: Re: Seperate Tabs in Excel Output based on Groups
Post by: rpvs on 06 Nov 2009 03:30:25 PM

Thanks for all your reply. I got side tracked into another major issue and am getting back into the cognos world now and will be trying it out.I will be posting on the results when done.

Thanks again.

Title: Re: Seperate Tabs in Excel Output based on Groups
Post by: alliejoy on 14 Jan 2010 12:02:22 PM

I have a similar question, if we default the report output to excel and each pageset is an excel tab, is there a limit/maximum of how many there could be?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Query Studio => Topic started by: rpvs on 05 Nov 2009 10:03:04 AM