Using default and fixed parameter values

Variables can have these values:

  • A value for the current user
  • A default value
  • A value for a specified user or role

See Variables.

To display the default value in the Report Wizard, select Default (users can still select a different value).

To prevent users selecting a different value for a parameter, select Fixed.

If the default value of a variable refers to an object that no longer exists (for example, a deleted database alias) then the first available object of that parameter type is used.

Example

You have 3 database aliases named B, C and D, and a variable to store their values.

The default value of the Alias variable is A.

You select A as the default value of the alias in the template report.

In the Report Wizard, B is displayed. If the alias has dependencies (for example, a cube), the dependencies of B are displayed. ’A’ cannot be selected.

If the default values of parameter types ’Boolean’ and ’Operator’ are not valid, the values ’False’ and ’=’ (equals) respectively are used.