Use Multivalue parameter in an expression in Paginated Report

[SowjanyaB]

Hi,

We are using the SQL Query in an expression to pass parameter value. How can I pass multiple values using a parameter and the values are text. 

Thanks,

Sowjanya

[Anonymous]

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 Build...

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.

[SowjanyaB]

I am using the entire SQL query in Query Type -> Text -> expression as i see a limitation passing parameters in Querry Type -> Text for DB2 database.

[ajohnso2]

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