Changes

Using Data from a Report as Criteria for Another Report

57 bytes added, 17:33, 21 August 2013

no edit summary

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

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

Fr 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 column (there are 3 columns on report one) and 0 means the column contains numbers.

 

==See Also==

[[Determining the reportid]]

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

• ← Older edit
• Newer edit →

Arthur Lathrop

8,849

edits