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

Prompt and Filter for Multi value Text Item

Started by wwconslt, 04 Nov 2022 08:32:21 AM

Previous topic - Next topic

wwconslt

Hello,

I'm trying to create a value prompt that will allow a user to make a selection from a multi value text item separated by semi colons.

So the multi select value prompt looks like this:

Blue
Green
Red
Yellow

And the data item it will filter is based on this:

Blue; Green; Red; Yellow

The parameter I'm using is [All Colors] in ?Select Color? but it is selecting all the colors in the data item, not the one(s) I select. How do I get it to just return Blue for example?

Currently, if I select Blue, it returns everything. For example, it will return rows where Red is the only value in the text item.

I just discovered when I use [All Colors] contains ?Select Color?, it works but the prompt no longer allows multiselect--only one value. Is there a work around?

Thank you.