If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Show/Hide page based on value prompt

Started by Roon3y, 04 Mar 2013 11:28:50 AM

Previous topic - Next topic

Roon3y

Hello All,

I have been trying to achieve this for a while now (not too long) but tried  a lot of different tricks, tried rendering but i couldn't get it to show when i do select yes and bunch of stuff. Even tried http://www.ibm.com/developerworks/forums/thread.jspa?threadID=378822 but was not successful. So anything will help, just throw at me.

What i am trying is Value prompt (with drop down Yes or No), if selected yes show the detailed page and if selected no don't show it at all (not even blank white page, i was getting this when i did render var). So what would be the best way to do this.

Thanks for any help in advance.

Lynn

I would suggest a render variable on the detail page.

The link you posted may not have worked for you due to the difference between ParamValue and ParamDisplayValue. ParamValue will return the 'use' value of your parameter. ParamDisplayValue will return the 'show' value of your parameter.

Say your parameter is p_Hide and your static choices for use/display are 0/Hide and 1/Show. To reference the 'use' value in your boolean variable use this expression:

ParamValue('p_Hide') = '1'

To reference the 'display' value in your boolean variable use this expression:

ParamDisplayValue('p_Hide') = 'Show'

Navigate to the page level properties for your detail page and specify your variable as the render variable.

Good Luck!

Roon3y

Quote from: Lynn on 05 Mar 2013 07:52:04 AM
...ParamValue and ParamDisplayValue...

Thank you so much... it was this what was making me confuse but now i got it to work, the only problem now is that blank page showing up but this will work for now.

Thank You

Lynn

You shouldn't get a blank page if you set the render variable on the page level property. If you set the render variable on your data container (e.g., list or crosstab or chart or whatever) then the page will still render but with nothing on it.

If you click anywhere on the page and then use the ancestor button to navigate to the page level, you can set the render variable there and then shouldn't see the page at all.

Roon3y

#4
Yes tried doing it that way and i went to page explorer and selected the page i wanted render, but still same result.

EDIT: blank pages shows up when i run it in html, but when i do pdf it's not there so thats good. Thank You.