Using Data from a Report as Criteria for Another Report
From SmartWiki
Revision as of 13:36, 21 August 2013 by Arthur Lathrop (talk | contribs)
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.
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 report id, 1 means use the data in the 1st column of that report, and 0 means that that column contains numbers as opposed to text strings.