COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: chaganti26 on 29 Aug 2011 02:34:43 AM

Title: How to hide value prompt?
Post by: chaganti26 on 29 Aug 2011 02:34:43 AM
I Have a 2 value prompts
first value prompt contain static choices A,B Values
second value prompt contain yes or no values

in first value prompt if i select 'A' value then second 'Value prompt' must be hide
if i select 'B' VALUE then show the second prompt

THANKS
AR
Title: Re: How to hide value prompt?
Post by: a.chamkeri on 30 Aug 2011 05:05:50 AM
Hi,

Create a string variable (conditional) and use the 1st prompt in the calcuation.
eg. if (ParamDisplayValue('REPORT_TYPE') = 'A') then 'A' else 'B'
Create 2 values for this variable A and B.
Assign this variable to the  "Style variable" property of the 2nd prompt.
If the value of the varibale is A then set the "Box type" property of the 2nd prompt to NONE.