You can use a report to create a Filter, then use it on another Report. This design will generate an additional SQL pass in which a TEMPORARY table is generated with the inner Report condition. To create a filter based on a report, drag and drop the Filter to the Filter editor.