Difference between revisions of "Passing Prompt Criteria to a Sub-Report"
From SmartWiki
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|thumbnail]] | ||
[[Category:Reports]][[Category:Criteria]] | [[Category:Reports]][[Category:Criteria]] |
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.