Difference between revisions of "Using Data from a Report as Criteria for Another Report"
From SmartWiki
m (Updated syntax and added additional detail around specifying column number.) |
|||
| 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''''' | + | :<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. | 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 of that report, and ''0'' means that that column contains numbers as opposed to text strings. | + | 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== | ==See Also== | ||
Latest revision as of 16:42, 22 June 2015
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 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).
