Requirement : We need to filter dynamically query based dataset based on another dataset which may be of different type(Query based or RDP).
For example let us consider two datasets in an SSRS report.
DataSet1 : Query based (we need to filter this query based on dataSet2)
DataSet2 : Query based or RDP.
both dataSets have one field in common .so based on the dataSet2 we need to filter Dataset1
Could you please guide us how to achieve this.