Multi value parameter in paginated reports (in single parameter)

[abhijsrwaaa]

I am looking to implement multi value parameter in paginated reports for a sql server connection. The values just generate for 1st value not for others.

I have tried all possible ways join, split string, nothing works.

Can someone point me in correct direction?

Or a blog, video, step guide.

Thanks.

[v-yohua-msft]

Hi, @abhijsrwaaa 

First, make sure that the settings for the multi-value parameter are configured correctly. You can check out the following links:

Add a multi-value parameter to a paginated report - Microsoft Report Builder & Power BI Report Build...

Create and use the paginated report visual - Power BI | Microsoft Learn

If SQL Server uses the Always Encrypted column, there are specific limitations when using the multi-value parameter. According to Always Encrypted, the multi-value parameter cannot be used with multiple values of the Always Encrypted column. If applicable, this limitation may affect the functionality of the report. Information can be found in

the following documents:

Always Encrypted in Power BI Report Server - Power BI | Microsoft Learn

To resolve the issue of multi-valued parameters in paginated reports, you must ensure that the report handles the parameter values correctly. The process involves passing multiple parameter values in the report URL and configuring the report parameter properties to allow multiple values. For more details, see the sections:

Pass a report parameter within a URL - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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