Hello,
Anyone knows what is the SSRS expression to take multiple values of a parameter separated by comma? I tried many different expressions but it did not work.
=split(replace(Parameters!param1.Value," ",""),",")
=split(Parameters!param1.Value,",")
=Parameters!param1.value + ","
=Split(Join(Parameters!param1.Value,”,”),”,”)
Below is my sql query and when I executed it, sql returned multiple values of my @param1 parameter but my SSRS does not. So, it works in SQL but not when I use the same query in SSRS.
DECLARE @param1 varchar(max)
SET @param1 = 'A,B,C,D'
SELECT tbl.column1
,tbl.column2
,tbl.column3
,tbl.column4
,tbl.column5
,tbl.column6
,tbl.column7
,tbl.column8
FROM TableTbl tbl
WHERE @param1 IS NULL OR Exists ( SELECT 1 FROM dbo.splitparameter(@param1,',') b
WHERE b.values = tbl.column1
OR tbl.column2
OR tbl.column3)))