Using Data from a Report as Criteria for Another Report

The result data set from a report can be used as criteria for another report using the following syntax:

@Report[reportid,column #,data type]@

where data type is 0 for numbers and 1 for text

on report one (id=12345) - select tracking id, firstname, lastname from funding uta where userid=@userid@ (current user) and rolename="Conflict"

This return all item where current user is in conflict.

on report two -select tracking id, funding name, panel name from funding uta, panel uta where panel user=current user This return all funding item where current user is in panel committee.

Next step is to put report one as a criterion on report two.

userid=@userid@ and userid NOT IN( @Report[12345;1;0]@ )

where 12345 is the report id, 1 means use the data in the 1st column (there are 3 columns on report one) and 0 means the column contains numbers.