on report one (id=12345) - select tracking id, firstname, lastname from funding uta where userid=@userid@ (current user) and rolename="Conflict"
This return Fr example, if report 12345 has the userid of all item where current user is level 1 owners for a particular UTA, the following criteria could be used in conflict. on another report two -select tracking id, funding name, panel name from funding uta, panel uta where panel user=current userThis return all funding item where current user is to filter for only those users found in panel committee. Next step is to put report one as a criterion on report two12345. 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.
