Hi, I have one issue with pr

[kejalg]

Hi,

I have one issue with prompts. I am listing 4 values in the prompt with multi-select on. If the user selects all the 4 values, Then the filter in the where clause makes no sense as there are only those 4 possible values in the database. I wonder if there is a way to remove the filter at all if the user selects all the 4 values.

thanks in advance.

-Kejal

 

[kajarekar]

Hi Kejal,

You can try putting an 'ALL' value in the prompt. There is enough material available on this technique either on this discussion forum or cognos knowledgebase.

.... Vivek