show/hide block in report

[RiesBruins]

Hi all,

I hope that one off you can point me in the right direction. I have a report with a list in a block and a singleton. What i would like that is if a user click on the singleton the block becomes visible.

I have placed the singleton on a promptbutton so when the user click he clicks the button but now i need to set the Parameter so that the block becomes visible.

I hope that someone can help me

Thanks in Advance

Richard Bruins
Netherlands

[addpremkumar]

Can you please be clear on your requirement.

I am not sure why u r using singleton to hide/shpw a block?

[RiesBruins]

I have a report that shows  an average value in a singleton. The idea is that a user can click on the singleton and than a list becomes visible that shows the detail values that are used to calculate the average.

I have tried to use a prompt button but I have to use a parameter before the conditional block becomes visible. Now I use a pick list and the value I chose makes a column of the list visible (conditional style)

I hope you can help me

Thank in advance

Richard Bruins
Netherlands
P.S. I use cognos 8.3

[pratheek_g]

Hi ,
i think you need to use the Render variable.This work like this.
Create a prompt and add L,L1,L2,L3,L4 as L,L1,L2,L3,L4 are your data items in the report.Then create 5 boolean variables.
Now click on the column L and select List column from properties. And in "Render Variable " select the respective variable for that column and default is yes. Do same for all.
Now when u run, prompt(Multi -select) will ask to select the required columns and report will display only those columns remaining will be hidden.
thanks.

[RiesBruins]

Thank you for the reply. I will try it and let uyou know