Print Page - Need a value prompt to select multiple items and use wildcard

Title: Need a value prompt to select multiple items and use wildcard
Post by: bignadad on 26 Sep 2013 05:38:36 PM

I have this filter currently setup on my query and it works [Replenishment Code] contains ?vendor?

However i need to replace "contains" with "in" to get multi select working in my value prompt

BUT, i am not able to add a wildcard to the "in" operator like so [Replenishment Code] in ?vendor? + '%'

Is there any way to do this?

My replenishment code is setup like this AIPRODU-WA AIPRODU-SF etc...

But i had to substring ?vendor? to everything before the "-". so you see AIPRODU

Title: Re: Need a value prompt to select multiple items and use wildcard
Post by: Lynn on 07 Oct 2013 10:46:02 AM

Can you use a search and select prompt?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: bignadad on 26 Sep 2013 05:38:36 PM