pass parameter between different datasets

[Anonymous]

If we want to make a report based on two datasets, is it possible to choose report date from one dataset and get report from all datasets filtered to this report date?

[Jon-Heide · Accepted solution]

If you are referring to a paginated RDL report, yes. You would need to use cascading parameters, bound to different datasets. Just set value of one parameter to be a filter for the next, you can see a general overview here:  https://docs.microsoft.com/en-us/sql/reporting-services/report-design/add-cascading-parameters-to-a-...