Difference between revisions of "Using Data from a Report as Criteria for Another Report"

From SmartWiki
Jump to: navigation, search
Line 6: Line 6:
  
  
−
on report one (id=12345) - select tracking id, firstname, lastname from funding uta where userid=@userid@ (current user) and rolename="Conflict"
 
  
−
This return all item where current user is in conflict.
+
Fr 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]@ )
−
 
 
−
on report two  -select tracking id, funding name, panel name from funding uta, panel uta where panel user=current  user
 
−
This return all funding item where current user is in panel committee.
 
−
 
 
−
 
 
−
Next step is to put report one as a criterion on report two.  
 
−
 
 
−
userid=@userid@ and userid NOT 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.
 
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.

Revision as of 08:06, 12 September 2011

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


Fr 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.

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Using_Data_from_a_Report_as_Criteria_for_Another_Report&oldid=11117’