Difference between revisions of "Passing Prompt Criteria to a Sub-Report"

From SmartWiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
When prompting for user input criteria in a report using '''???''' you can handover the selected criteria to a sub-report.
+
When [[Prompting for Criteria in Reports|prompting for user input criteria]] in a report using '''???''', you can handover the selected [[:Category:Criteria|criteria]] to a sub-report.
  
 
For example, if there are 3 user input parameters (???) on the main report:
 
For example, if there are 3 user input parameters (???) on the main report:
Line 14: Line 14:
  
 
For the example above the sub-report criteria would be ''@args[1]@'', ''@args[2]@'' and ''@args[3]@'' for ''startdate'', ''enddate'' and ''owner name'' respectively.
 
For the example above the sub-report criteria would be ''@args[1]@'', ''@args[2]@'' and ''@args[3]@'' for ''startdate'', ''enddate'' and ''owner name'' respectively.
 +
<!--search keywords: subreport SubReport-->
  
[[Category:Reports]]
+
[[File:Subreport Args.PNG]]
 +
 
 +
[[Category:Reports]][[Category:Criteria]]

Latest revision as of 16:47, 19 June 2015

When prompting for user input criteria in a report using ???, you can handover the selected criteria to a sub-report.

For example, if there are 3 user input parameters (???) on the main report:

  • startdate
  • enddate
  • owner name.

The values entered for each of these parameters will be passed to the Sub-Report(s) and can be called using the following variable syntax in the criteria field of the sub-report:

@args[number]@

where number is the sequence of the ??? criteria (1, 2, 3, etc)


For the example above the sub-report criteria would be @args[1]@, @args[2]@ and @args[3]@ for startdate, enddate and owner name respectively.

Subreport Args.PNG