Forum Discussion
pass parameter between different datasets
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
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