How to filter SSRS report with multivalue parameters works like a string.contains -


i have ssrs report calls stored procedure result set. 1 of column "owner" column can have 0 or more person name , string concatenated " & ". can't change stored procedure in report need add multivalue report parameter. parameter displays possible owner name in drop down , need use parameter post-filter after result set stored procedure call. question how create filter on owner field works string.contains? better illustrate, below example:

below raw result set

ticket number owner 100           john doe & jane doe 101           john doe & jack smith 102           john doe & bill white 

if user selects jack smith , bill white in owner parameter drop down, result should be

ticket number owner 101           john doe & jack smith 102           john doe & bill white 

if john doe selected, 3 rows should returned.

you this.

 declare @string nvarchar(10)  set @string = 'string'   owner '''' + '%' + @string + '%' + ''''  

which should give

where owner '%string%' 

Comments

Popular posts from this blog

sublimetext3 - what keyboard shortcut is to comment/uncomment for this script tag in sublime -

java - No use of nillable="0" in SOAP Webservice -

ubuntu - Laravel 5.2 quickstart guide gives Not Found Error -