Print Page - How do I filter a Report Page?

Title: How do I filter a Report Page?
Post by: farmcock on 10 Apr 2014 09:54:07 AM

I have a report with multiple "pages" in Page Explorer - one page for each "Region" of our Company. My query pulls back all the data for all regions. My problem is getting each "Report Page" to only render the data rows for its Region. How can I do this without having multiple queries?

There must be a way! >:(

Thanks. :)

Title: Re: How do I filter a Report Page?
Post by: BigChris on 10 Apr 2014 10:31:56 AM

Assuming that the page for each region is the same, it sounds like you need a page set, split by region

Title: Re: How do I filter a Report Page?
Post by: farmcock on 10 Apr 2014 01:32:39 PM

That sounds great! Can I do that without a seperate Query for each Region? I'm pulling back all data for all regions in one query.
How would i do the Page Set Splits?

Title: Re: How do I filter a Report Page?
Post by: Lynn on 10 Apr 2014 01:40:15 PM

Google comes in handy.

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cr_rptstd.8.4.0.doc/ug_cr_rptstd_id28446cr_rptstd_frmat_rep_create_page_set.html

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: farmcock on 10 Apr 2014 09:54:07 AM