Report Builder

A multi-value parameter will be passed as a comma-delimited NVARCHAR string. Parse with string_split(@parametername, ',') which returns a table. If you want you strings to be INTs then do something like SELECT CAST(value AS INT) FROM string_split(@parametername, ',') You can use the SELECT in your WHERE clause, e.g. WHERE COLUMN_NAME IN ( SELECT CAST(value AS INT) FROM string_split(@parametername, ',') ) SQL Server Profile starts at 11:40

https://www.wiseowl.co.uk/report-builder/videos/report-builder-2016/multi-value-parameters-stored-procedures/ SQL Profiler starts around 12:28 Capture RPC Completed event; include TextData You will see the multi-valued parameter passed to the stored procedure as N'(1,2,3) NVARCHAR comma-separated list add WHERE clause to your query to parse the comma-delimited list: WHERE Branch IN (     SELECT CAST(value AS INT) as INTVALUE     FROM STRING_SPLIT(@paramvalue, ',') ) example: @Branch parameter is NVARCJAR(MAX) add WHERE clause: where    bor.BRANCH IN ( SELECT CAST(value AS INT) AS Branch FROM STRING_SPLIT(@Branch, ',') )

39:00 begins modifying the report table

https://www.wiseowl.co.uk/report-builder/videos/report-builder-2016/multi-value-parameters/