Report Parameters

Report Parameters

 

System Parameters

Using a pre-defined system parameter

To use a system parameter:

1.      In the Object Navigator, expand the Data Model node, then expand the System Parameters node.

2.      Double-click the properties icon for the desired parameter to display the Property Inspector.

3.      Under the Parameter node, set the Initial Value property, if required.

4.      To validate the parameter’s value at runtime, set the Validation Trigger property by clicking the … button to display the PL/SQL Editor and define the PL/SQL to be triggered at runtime.

User Parameters

Creating a user parameter

Note: Reports Builder automatically creates a user parameter when you use a bind parameter reference in a query

To create a user parameter:

1.      In the Object Navigator, expand the Data Model node, then click the User Parameters node.

2.      Click the Create button in the toolbar.

3.      Double-click the properties icon for the new parameter to display the Property Inspector.

4.      Under the General Information node, replace the Name property with the desired parameter name.

5.      Under the Parameter node, set the Initial Value and List of Values properties, if required.

6.      To validate the parameter’s value at runtime, set the Validation Trigger property by clicking property field to display the PL/SQL Editor and define the PL/SQL to be triggered at runtime.