Sync Two Parameters in Paginated Report

Hi prakash11440278 ,

 

You can create the output of ReportParameter1 as a new dataset in a paginated Report, then reference the dataset in ReportParameter2 to synchronize the parameters.
The following are the detailed steps.
1. I have DataSet1 and ReportParameter1 in my report with the following properties.

 

    

 

2. I want to create ReportParameter2 and synchronize it with ReportParameter1. First create a new DataSet2, enter the query and reference the output of ReportParameter1 in the query.

 

SELECT
  DimProductCategory.ProductCategoryKey
FROM
  DimProductCategory
where DimProductCategory.ProductCategoryKey in (@ReportParameter1)

 

3. Then create ReportParameter2 and select "Hidden". Its available values and default values are set to the fields in DataSet2.

 

   

 

4. Then create two visuals to filter using ReportParameter1 and ReportParameter2 respectively.

     

 

5. After running, you can see that only ReportParameter1 is showed, and if ReportParameter1 is selected 2, 3, ReportParameter2 will be synchronized as well.

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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