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

From SmartWiki
Jump to: navigation, search
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.
  
[[Category:Reports]]
+
[[Category:Reports]][[Category:Criteria]]

Revision as of 09:07, 30 April 2013

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.