Print Page - Need to display a report in diffrent worksheets

Title: Need to display a report in diffrent worksheets
Post by: lifzgud on 04 Sep 2009 04:41:48 AM

I need to display a report in diffrent worksheets subdivided by a column A
eg if A has values 1,2,3,4,5
I have to display data pertaining to it in 5 diffrent worksheets.
Plz reply as its urgent ???

Title: Re: Need to display a report in diffrent worksheets
Post by: blom0344 on 04 Sep 2009 04:58:45 AM

5 worksheets = 5 report pages (not pages, REPORT pages) and you'll get seperate worksheets in an Excel workbook.

Is that what you are after?

Title: Re: Need to display a report in diffrent worksheets
Post by: billylodz on 04 Sep 2009 05:45:44 AM

use page set

http://www-01.ibm.com/support/docview.wss?rs=3442&q1=page+set&q2=report+studio&uid=swg21339198&loc=en_US&cs=utf-8&cc=us&lang=all

Title: Re: Need to display a report in diffrent worksheets
Post by: lifzgud on 04 Sep 2009 06:08:38 AM

I want 6 worksheets.one master and 5 according to division number,There are 5 divisions
As of now i have created a single report.

Title: Re: Need to display a report in diffrent worksheets
Post by: lifzgud on 04 Sep 2009 08:06:39 AM

Hi
Page sets are worling fine but i need a distinct count on a column ..i am facing some issues
1)Getting the count on the last page not on all the pages
2)I am not able to change the SQL for the report.I need to change the count to distinct count
3)I needed to display the original master report as well in the first worksheet...only then i create the five worksheets

Thanks

Title: Re: Need to display a report in diffrent worksheets
Post by: billylodz on 04 Sep 2009 09:34:00 AM

just add page before page set and use the same crosstab

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lifzgud on 04 Sep 2009 04:41:48 AM