COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: rtikat on 08 Nov 2011 10:51:12 AM

Title: Filtering for multiple values in a text prompt
Post by: rtikat on 08 Nov 2011 10:51:12 AM
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?
Title: Re: Filtering for multiple values in a text prompt
Post by: HalfBloodPrince on 09 Nov 2011 04:19:16 AM
you have to make it  multiselect so that it wil work like select and search prompt.

Thanks,
Title: Re: Filtering for multiple values in a text prompt
Post by: rtikat on 09 Nov 2011 12:52:13 PM
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.
Title: Re: Filtering for multiple values in a text prompt
Post by: HalfBloodPrince on 10 Nov 2011 10:41:15 PM
Check what values are passed to the filter using Layout Calculation. and then try the step i told above.