Forum Discussion
pass parameter between different datasets
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?
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-report-report-builder-and-ssrs?view=sql-server-ver15
1 Reply
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-report-report-builder-and-ssrs?view=sql-server-ver15