Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chris2001dc on 29 Apr 2009 11:09:47 AM

Title: Page set
Post by: chris2001dc on 29 Apr 2009 11:09:47 AM
Hi,

I am working with Cognos 8.3, I have a report that is configured to break pages by an attribute (REGION).  I have this issue, I need to break the pages but each page has to have two REGION, is this possible??

Thanks
Title: Re: Page set
Post by: kalyan_y on 04 May 2009 05:43:08 AM
If the no. of regions is minimum, we can go for a dataitem with a case expression, say case when region = 'India' then 1, when region = 'Srilanka' then 1 when region = 'Bangladesh' then 2 when region = 'Pakistan' then 2 .... so on and have a page set on this data item...
Title: Re: Page set
Post by: m23 on 04 May 2009 09:08:53 PM
Add a new data item to your page set query with the following expression.

round(running-count(1)/2,0)

Then base your pageset on this data item.
Text only | Text with Images