Use Multivalue parameter in an expression in Paginated Report

Are you are asking how to pass multi value parameter values into a 'SQL' expression (from within Paginated Reports)?

If so you can simply wrap your parameter expression in join syntax.

- Join(Parameters!<Your Param Name>.Value, ",") -- this effectively creates a row of comma seperated values

Hi SowjanyaB ,

You can add a parameter to a paginated report that allows the user to select more than one value for the parameter.

There's an official document about this. Please kindly refer to

Add a multi-value parameter to a paginated report - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Also, you can pass multiple parameter values to the report within the report URL. For more information, see Pass a report parameter within a URL.

For information on how to pass multiple parameter values to a stored procedure, see Work with multi-select parameters for SQL Server Reporting Service Reports on mssqltips.com.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.