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') ) ) ) ) ) ) # )