If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filtering for multiple values in a text prompt

Started by rtikat, 08 Nov 2011 10:51:12 AM

Previous topic - Next topic

rtikat

Hi - I have a text prompt where I want users to enter multiple strings in order to search for those strings within a field.  My filter is something like [Some field] contains ?prompt?  or ?prompt? in [Some field] but doing this makes the text prompt only accept one value.  What syntax can I use in the filter so that the prompt will still allow multiple values to be entered?

HalfBloodPrince

you have to make it  multiselect so that it wil work like select and search prompt.

Thanks,

rtikat

I did make it a multi select but it still doesn't work - if I change the filter to [some field] in ?prompt? then it allows multiple values, but the other filter syntaxes do not allow the multiples and I don't understand why.

HalfBloodPrince

Check what values are passed to the filter using Layout Calculation. and then try the step i told above.