Parameters

 A parameter is a variable whose value can be set at runtime. Parameters are especially useful for modifying and setting PL/SQL variables at runtime.

Using Tratum Reporting Manager, you can create parameters to replace either single literal values or entire expressions in any part of a query. You can reference parameters elsewhere in the report, such as in PL/SQL constructs providing conditional logic for the report.

 Example Scenario:

Report generated using ‘Single Table’ option with parameter assigned.

Report generated using ‘Multiple Table’ option with Parameter assigned.

Select a report name that has ‘Parameter’ assigned to it from the left pane.A popup is displayed, enter the parameter values and click on ‘Run Report’ to generate the report.

If the user wants to change the values passed at parameter.Select the ‘Parameters’ option at the toolbar, the popup is displayed with the existing values and conditions. Change the value/values with a new value and run the report. The dataset query retrieves only the data that is requested.