Page set

[chris2001dc]

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

[kalyan_y]

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...

[m23]

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.