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

From SmartWiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 15: Line 15:
 
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-->
 
<!--search keywords: subreport SubReport-->
 +
 +
[[File:Subreport Args.PNG]]
  
 
[[Category:Reports]][[Category:Criteria]]
 
[[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