Filtering Query based dataSet in SSRS Report in Visual studio(AX2012)

Hi all,

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.


Please refer this link and let me know incase of any suggestions