set a filter for child table according to a parent Table

[Khaoula Brida]

I have a parent table (Case table) and two children table ( Request and case task table).

I want to create a report with following filter Condition: price grather than 0$ from the request table and only open state from the case task table and the assignment group from the parent table.  How can i set this filter

[Mark Manders]

Use the related list conditions. You create the report on the Case table, showing the assignment group and through the related list conditions you check on at least 1 RITM of more than 0 and at least 1 open case task record.

If it is about showing fields from the child tables, you will need to create a database view.