Passing Prompt Criteria to a Sub-Report

From SmartWiki
Jump to: navigation, search

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