1.add report
2.add dataset
3.edit param be mulit

2.在CR #Add DataSet

Query type : Text
Query :

select * from
(
select '1' as ID
union select '2'
union select '3'
union select '4'
union select '5'
) a
where ID in (@pal)

检查1.Parameters 会出现@pal
检查2.DataSet出现栏位

3.编辑@pal-Report Parameter Properties

#编辑@pal

Data type : Allow multiple values

使用变数

JOIN(Parameters!pal.Value,",")

显示 : ●金 或○金
=IIF
(
JOIN(Parameters!pal.Value,",").Contains("1,2,3,4,5")=true 
,"○"
,IIF
(
JOIN(Parameters!pal.Value,",").Contains("1")=true 
,"●","○"
)
) & "金" 

显示 : ●ALL 或○ALL
 
=IIF
(
JOIN(Parameters!pal.Value,",").Contains("1,2,3,4,5")=true 
,"●"
,"○"
) & "ALL"

如果使用SP也可以

1.

在SQL SERVER add proc : sp_xxx @pal

create proc sp_xxx @pal varchar(max)
as
create table #tmp
(
ID varchar(8)
)
insert into #tmp select 1
insert into #tmp select 2
insert into #tmp select 3

select * from #tmp where @pal like '%'+ID+'%' --这里要注意,要写成这样.

2.

Query type : SP *这里要选SP
Query : sp_xxx

ref
https://dotblogs.com.tw/terrychuang/2011/06/14/28315
https://www.sqlshack.com/using-multi-value-parameters-in-ssrs/