« previous next »
Pages: [1]

Author Topic: Seperate Tabs in Excel Output based on Groups  (Read 1019 times)

Offline rpvs

  • Full Member
  • ***
  • Posts: 25
  • Forum Citizenship: +0/-0
Seperate Tabs in Excel Output based on Groups
« on: 05 Nov 2009 10:03:04 pm »
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??


Logged

Offline Gopinath

  • Community Leader
  • *****
  • Posts: 176
  • Forum Citizenship: +12/-0
Re: Seperate Tabs in Excel Output based on Groups
« Reply #1 on: 06 Nov 2009 12:32:36 am »
Create a PageSet and and Set the Grouping as Productline
Logged

Offline rpvs

  • Full Member
  • ***
  • Posts: 25
  • Forum Citizenship: +0/-0
Re: Seperate Tabs in Excel Output based on Groups
« Reply #2 on: 07 Nov 2009 03:30:25 am »
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.
Logged

Offline alliejoy

  • Full Member
  • ***
  • Posts: 6
  • Forum Citizenship: +0/-0
Re: Seperate Tabs in Excel Output based on Groups
« Reply #3 on: 15 Jan 2010 12:02:22 am »
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?
Logged
Pages: [1]
« previous next »