COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 27 Sep 2016 09:36:05 AM

Title: How to extract the 10 raport page into different tabs in excel.
Post by: inu on 27 Sep 2016 09:36:05 AM
Hi Team,

Can you please help me in this regard..

Is there any function do i need to use at report level.


Regards,
Inam
Title: Re: How to extract the 10 raport page into different tabs in excel.
Post by: cognos-t on 27 Sep 2016 09:53:19 AM
Hi,

this pretty much depends on your requirements and report structur.

You basically have 2 possibilties:

1) Create 10 pages in Report Studio. Every page will produce a single tab.
2) Create a page set to generate different tabs based on a specific data item.

Best regards
Title: Re: How to extract the 10 raport page into different tabs in excel.
Post by: inu on 30 Sep 2016 12:10:12 AM
Quote from: cognos-t on 27 Sep 2016 09:53:19 AM
Hi,

this pretty much depends on your requirements and report structur.

You basically have 2 possibilties:

1) Create 10 pages in Report Studio. Every page will produce a single tab.
2) Create a page set to generate different tabs based on a specific data item.

Best regards


Appreciate your response, can you please clarify it as in steps. as i am not much experienced.


Regards,
Inam
Title: Re: How to extract the 10 raport page into different tabs in excel.
Post by: Michael75 on 30 Sep 2016 02:17:12 AM
QuoteAppreciate your response, can you please clarify it as in steps

Inam,

Do you know that IBM Cognos provides extensive, and in most cases very useful documentation for their software? Have you looked in the Report Studio User Guide?

Here, you'll find, under Chapter 20. Working with Multiple Pages, two topics:
- Add a Page to a Report
- Page breaks, page sets, and page layers

which will give you all you need. I think it unlikely that a forum member will go to the trouble of typing out info that is already freely available. I know I wouldn't.