Difference between revisions of "Using Data from a Report as Criteria for Another Report"
| Line 1: | Line 1: | ||
The result data set from a report can be used as criteria for another report using the following syntax: | The result data set from a report can be used as criteria for another report using the following syntax: | ||
| − | :<font size="3">'''@Report['''''reportid'',''column #'',''data type''''']@'''</font> | + | :<font size="3">'''@Report['''''reportid''''','''''column #''''','''''data type''''']@'''</font> |
where data type is 0 for numbers and 1 for text | where data type is 0 for numbers and 1 for text | ||
Revision as of 08:03, 12 September 2011
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.
