Prompts and Filters behaviour

[shanmku]

Hi,

Since we are new to Cognos 8 Report Studio. We would like to clarify few things about Prompts and Filters behaviour.

The scenario is, we have a value prompt which contains static choices and multiple selections enabled in it. It uses a param variable called 'prmReqType'. When the user selects an item from the list, In the filter expression, I am comparing it like ((?prmReqType?) = 'Employment Specialist'), If this is true then I am adding (

.[SPECIALIST] is not NULL).

When I run the report, the value prompt shows up like which doesn't allow multiple selection in it. I figured this problem is happening due to the = sign that I have used it in the filter.

I've tried so many different things, but never got a solution yet.

Experts please advice. Thanks in advance.

Regards,
Kumar

 

[Draoued]

have you tried the opposite :
( 'Employment Specialist' in (?prmReqType?)) because your
?prmReqType? can be a list of items.

 

[shanmku]

Yes, I tried the opposite. But ended up getting the sql error like "An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'."

Let me know. Thanks for your support.

Kumar

 

[wendose]

I think Deaoued is on the right track, you need to put an IN clause rather than '='