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
(users can still select a different value).To prevent users selecting a different value for a parameter, select
.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.