Note: Reports Builder automatically creates a user parameter when you use a bind parameter reference in a query.
To create a user parameter:
In the Object Navigator, expand the Data Model node, then click the User Parameters node.
Click
in the toolbar.
Double-click
(the properties icon) for the new parameter to display the Property Inspector.
Under the General Information node, replace the Name property with the desired parameter name.
Under the Parameter node, set the Initial Value and List of Values properties, if required.
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.
Next step
Creating a list of values (LOV) for a parameter
Selecting parameters to include in the Parameter Form
Displaying the Parameter Form at runtime
About referencing columns and parameters
Validating a parameter value at runtime
Using a pre-defined system parameter
Copyright © 1984, 2005, Oracle. All rights reserved.