Difference between revisions of "Using Data from a Report as Criteria for Another Report"
From SmartWiki
| Line 3: | Line 3: | ||
:<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. |
| − | + | 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]@ ) | userid IN( @Report[12345;1;0]@ ) | ||
where 12345 is the [[Determining the reportid|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. | where 12345 is the [[Determining the reportid|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. | ||
| + | |||
| + | ==See Also== | ||
| + | [[Determining the reportid]] | ||
[[Category:Reports]][[Category:Criteria]] | [[Category:Reports]][[Category:Criteria]] | ||
Revision as of 13:33, 21 August 2013
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 (there are 3 columns on report one) and 0 means the column contains numbers.
