What does Select and Search prompt do?

IBM Cognos Report Studio provides a ‘Select & Search’ prompt. This prompt searches for a keyword and returns all matching values.

For example if you were searching for employees with the name ‘Jack’. The prompt searches and returns the values ‘Jack’, ‘Jackie’ or Jackzie’. Users can then choose the required employees and run the report.

Use a Select & Search prompt in 2 scenarios:

1. When you have too many values (too many to fit into a Value prompt)

2. When your values are case sensitive (For example, ‘Test’, ‘test’)

For example, in the image below we are searching for all employees with the name Jack