COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chandrapalreddyn on 17 Sep 2009 04:04:04 AM

Title: Page Break Based on Total
Post by: chandrapalreddyn on 17 Sep 2009 04:04:04 AM
Hi,
----Urgent Requirement---

I want to break the page based running total for EMP ID
like running total reaches <=10000 then
it should break the page.
I used the condition like when running total between 0 and 10000 then 1
between 10001 and 20000 then 2
and then i am grouping
like this.
But its working up to certain level
Title: Re: Page Break Based on Total
Post by: chandrapalreddyn on 21 Sep 2009 01:05:23 AM
 .
Title: Re: Page Break Based on Total
Post by: shahark on 21 Sep 2009 09:49:57 AM
Hi,

i think you should add a data item which will have the running total/10000.
then you will need to take the integer value.
if it's 0 - > the running total is between 0 and 10000
if it's 1 - > the running total is between 10001 and 20000
etc.

use this data item to make the page brek.
good luck

shahar