View source for 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:

:<font size="3">'''@Report['''''reportid''''';'''''column #''''';'''''data type''''']@'''</font>

where ''data type'' is ''0'' for numbers and ''1'' for text.

For example, if report 12345 has the userid of all level 1 owners for a particular UTA, the following [[criteria]] could be used in another report to filter for only those users found in report 12345.
 userid IN( @Report[12345;1;0]@ )

where ''12345'' is the [[Determining the reportid|report id]], ''1'' means use the data in the 1st visible column of that report, and ''0'' means that that column contains numbers as opposed to text strings.

The column # should indicate the VISIBLE column number when viewing the report, not the actual column number within the builder (columns with the 'Show' checkbox checked). 

==See Also==
* [[Determining the reportid]]


[[Category:Reports]][[Category:Criteria]]