TableA.Column1 in ElementList OR TableB.Column2 in ElementList

[dune1914]

Hi,

- We don't have Frame Woek Manager to see the joins between such and such tables and so we have to play with the report by dragging and dropping 2 columns from
2 different querie for example in order to see those joins BUT i must admit that SQL generate by Report Studio is kind of long even when only dealing
with 2 columns in a list for example.

- We need to created a list report that will display 5 columns
TableA.Column1 TableA.Column2 TableB.Column3 TableB.Column4 TableC.Column5

- We then need to fiter on TableAColumn2 in (ElementList) and on TableB.Column3(InSameElementList)

- We want to be able to treat all the following scenarios:

Records when "TableAColumn2 in (ElementList)" FILTER is acheived and when TableBColumn3 in (InSameElementList) FILTER is acheived
Records when "TableAColumn2 in (ElementList)" FILTER is acheived and when TableBColumn3 in (InSameElementList) FILTER is NOT acheived
Records when "TableAColumn2 in (ElementList)" FILTER is NOT acheived and when TableBColumn3 in (InSameElementList) FILTER is acheived

Can we and how do we acheive this ? CAN we bypass the joins between such and such tables in the FM model by doing them in Report Studio ? Or
will those from FM model will always precede those in Report Studio  ?

Thak you in advance to anyone willing to suggest some advices.