Seperate Tabs in Excel Output based on Groups

[rpvs]

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??

[Gopinath]

Create a PageSet and and Set the Grouping as Productline

[rpvs]

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.

[alliejoy]

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?