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
Can you please be clear on your requirement.
I am not sure why u r using singleton to hide/shpw a block?
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
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.
Thank you for the reply. I will try it and let uyou know