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

Hide/show cell depending parameter

Started by Revathi_M, 22 Oct 2014 01:22:08 AM

Previous topic - Next topic

Revathi_M

Hi any export can  explain me.
I have Table with two cell,and in promp i passing 2 valus -->1.Red,2.yellow

when i am select red 1st cell display and second cell hide
same like opposite when i select yellow parameter display 2nd cell hide 1st cell


anybody explain how to do this


thanks

BigChris

Does your table have two rows and one column (field), or one row and two columns? You're likely to need to use render variables, but it will depend on your situation.

jayatu

Hi Revathi_M

You can use an IF expression in your data item to achieve this (Considering you have two columns).

Create a data item with an expression like

if (?p_choice? = 'Red') then
([1st Cell])
else
([2nd Cell])

and use this data item in your report.

Jayatu

cognos810

Hello Revathi_M,
Use a conditional variable. Then apply Box Type property of the table cell to "None" depending on the prompt value selected.

-Cognos810