Forum Discussion

BishwaR's avatar
BishwaR
Helper V
4 years ago
Solved

Relationship between two query for Filter

I have two queries via ODBC connection from Oracle server. I not have have the physical tables for both  queries. I am using SQL to bring them to Report Builder. Now I want to use table A for the paramerter to filter the values in Table B.

 

I created the Selected Values in the parameter and it works perfectly but it does not filter table B because there is no relationship between them on the Primary columns. How can I create the relationship so that one table can filter other

 

Thank you