3 Parameters has to be sync from different tables in report builder pagainated report

Darshan_hello — Thu, 04 Jul 2024 08:59:04 GMT

I created 3 summary from 3 different Tables(summary 1, Summary2, Summary3)
and i have 3 Seperate Parameters for 3 tables, i want a solution when i apply filter to summary1 Parameter, then same filter has to be applied to summary2 and 3 Parameter(but there is no straight relationship for these 3, we dont need relationship also)
example1: When i hit paramter1="Bangalore" then autimatically Paramter2 & 3 has to filter "Bangalore" and give the results,

Please help to get the solution

Re: 3 Parameters has to be sync from different tables in report builder pagainated report

hackcrr — Thu, 04 Jul 2024 23:50:39 GMT

Hi, Darshan_hello

Open the Report Builder and your existing paged report. In the Report Data pane, right-click Parameters and select Add Parameter.
Name the parameter (e.g. LocationFilter), set the data type (e.g. Text), and configure any available or default values.
For each dataset (Summary1, Summary2, Summary3), right-click on the dataset and select Dataset Properties.
Go to the Parameters tab and add a new parameter that references the shared parameter you created. For example, set the parameter name to @LocationFilter and the value to =Parameters!LocationFilter.Value.

For each dataset, modify the query to include parameter filters. Example:

SELECT * FROM SummaryTable1 WHERE Location = @LocationFilter

SELECT * FROM SummaryTable2 WHERE Location = @LocationFilter

SELECT * FROM SummaryTable3 WHERE Location = @LocationFilter

In each summary table, configure the filter to use shared parameters. This ensures that the same filters are applied to all tables.

hackcrr

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

topic 3 Parameters has to be sync from different tables in report builder pagainated report in Report Server

3 Parameters has to be sync from different tables in report builder pagainated report

Re: 3 Parameters has to be sync from different tables in report builder pagainated report