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
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.
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
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