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

1 comment:

  1. Really a good work, all the one will really think about this. many of the one doing a good search on WWW, but for making A+ writing work choose a top essay writing services provider.

    ReplyDelete