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
Post a Comment