Showing posts with label multiple values in text box prompt. Show all posts
Showing posts with label multiple values in text box prompt. Show all posts

Tuesday, June 18, 2013

filter a report based on comma separated values entered in a text box prompt

Create a text box prompt with parameter like 'p'

enter the filter expression in detail filter as follows: 

cast(column name,varchar(200)) in ( #csv ( split(' ', split(',', split(' ,', split(' , ', split(', ', prompt('p','token') ) ) ) ) ) ) # )