Text box prompt with multiple values to filter

In some other forum I came across a solution to add multiple values in a text box prompt.

Say you want to filter a report on:

DEPARTMENT in (‘A’,’B’,’C’)

Drag in a text box prompt with a parameter: p_department

In the query add a filter with the next syntax:

[DEPARTMENT] in (#csv(split(‘,’,prompt(‘p_department’,’token’)))#)

Thanks to CognosPaul on www.cognoise.com

 

2 thoughts on “Text box prompt with multiple values to filter

  1. its not working. please give some more information

Leave a Reply

Your email address will not be published. Required fields are marked *