Difference between revisions of "Passing Prompt Criteria to a Sub-Report"
From SmartWiki
| (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 15: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.
