Controlling query overrides
When a user selects a report to run in the Report Console, the Override check box appears. If allowed, the user can determine whether a qualification added at runtime will override the query built into the report, or be added to the built-in query with an AND operator. The report creator or an administrator can configure settings in the Report form to control whether overrides are allowed.
Overrides do not affect a base qualification. Users can override a query built into the report definition, but if there is a base qualification defined in the Report form, the base qualification is always included when the report runs, whether or not Override is selected.
Override behavior is managed by these fields in the Report form:
- Override Query in Report? — This field sets the default value of the Override option in the Report Console. If this is set to Yes, the Override check box is selected, and if it is set to No, the Override check box is blank. This field is automatically set to Yes for BMC Remedy AR System reports and to No for Web reports.
- Lock Override Option — This field determines whether the Override check box is read-only in the Report Console. If this is set to Yes, the Override option is read-only and the user cannot select whether an added query will override the report query. If this is set to No, the user can change the Override option before running a report. The default value for this setting is No for both BMC Remedy AR System and Web reports.
By setting Override Query in Report? to No and Lock Override Option to Yes, you lock in the query in the report definition, so that the user can only further refine the query, and cannot broaden it.