A script-enabled browser is required for this page to function properly.

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 User Parameter Properties icon (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 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

See also

About parameters

About referencing columns and parameters

Validating a parameter value at runtime

Using a pre-defined system parameter