Conditional block for multi-selection prompt

[Chandrasekar]

Hi Guru's,

I have the scenario for  multi-selection prompt with conditional blocks in Cognos 10.2. Prompt fields are List report and crosstab report.

If i click list  report displays list report, If i click crosstab report displays crosstab report using boolean variable, Its works fine. When i am select both list and crosstab options its not work.
Please can you help me?

Thanks & Regards,
Chandrasekar.

[Francis aka khayman]

if you use boolean variable, you have to create a NOT condition as boolean variables only works on TRUE conditions.

you can instead use string variable with values: list, crosstab and both

[PRIT AMRIT]

Step-1 Instead of multi-select add another static values, List, Crosstab, All.
Step-2 Create a string varibale using your prompt parameter
Step-3 Associate the string varible to your conditonal block
Step-4 Based on the value you can asign type of reprots
Step-5 Make your prompt auto-submit

Hope it works.

Br,
Prit

[Chandrasekar]

Hi khayman,

So not possible to create multi-selections from boolean variable. Its correct.

Thanks & Regards,
Chandrasekar.

[Chandrasekar]

Hi Prit,

I checked already it works this way. In multi-selection list and crosstab both selected. In this situation boolean variable is possible? If possible, how to do that?

Thanks & Regards,
Chandrasekar.

[Lynn]

Others have provided good options to pursue, but I'd add that you could create two boolean variables. One for the list and one for the crosstab. Leave your prompt as multi-select with a choice for list and a choice for crosstab. Then in your list Boolean say something like:

Code Select Expand


ParamValue('YourParam') contains 'list'


Do the same for your crosstab Boolean variable except specify crosstab instead. The "contains" operator will allow each variable to render true if the specified item is selected or if both are selected.

[HalfBloodPrince]

try this

create one string variable with below code

if(ParamDisplayValue('Parameter1')='List') then

('List')

else
if (ParamDisplayValue('Parameter1')='Crosstab') then

('Crosstab')

else
('Both')

then while setting render varible for list select List and both , for Crosstab select Crosstab and both.

[Chandrasekar]

Hi HalfBloodPrince,

Thanks for your reply, I think it possible in single selection value prompt. Am i correct.

Thanks & regards,
Chandrasekar.

[Chandrasekar]

Hi Lynn,

Thank you very much for your reply. It works fine.

Thanks & Regards,
Chandrasekar.