COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Event Studio => Topic started by: S_N_Solution on 29 May 2009 04:05:46 AM

Title: Rows in the report more than 10 then need a popup
Post by: S_N_Solution on 29 May 2009 04:05:46 AM
Hi,

I want a popup window or msg when my report wold have rows more than 10.Only pop up or message should display.

Please help.....
Thanks in advance... :)
Title: Re: Rows in the report more than 10 then need a popup
Post by: Sridevi on 16 Jul 2009 07:47:28 AM
Hope you might have found the solution for this by this time. If not, try this

1. create a query calculation to calculate the count of a column in the list.
2. Place a text item inside a block in the report page with the text " report has more the 10 rows of data "  and make the box type of the block to none.
3. use this query calculation in the conditional variable (boolean variable) to check if the count is <=10. for Yes condition leave the box type of the block to be none and for the no condition set the box type of the block to block and the box type for the list to none

Let me know if this helps.

Thanks,
Sridevi