In the Ad Hoc Editor, you can display the input controls defined in the Topic as visible to users. You can accept the controls’ default values or enter other values. The Ad Hoc Editor indicates that the view has input controls by displaying 
as active on the tool bar. Click this icon to select new values or to save values as the new defaults for this view.
There are two types of input controls: Single select and multi-select. The input control type is determined by which operator you are using. In turn, the available operators are determined by what type of field (date, text, numeric, or boolean) you are using as a filter.
Single select controls present a calendar or drop-down list of values, from which you can choose a single value. Operators associated with this type of input control include:
Multi-select controls display a calendar or drop-down list of values, from which you can choose multiple values. You can click individual values to select them, or use shift-click to select multiple sequential values. Operators associated with this type of input control include:
To add an input control to the view using a filter:
|
1.
|
Create a new filter, or use an existing one in the Filters panel. |
|
2.
|
In the Filters panel, click the operator drop-down menu in the filter's title bar. |
|
3.
|
Select an operator from the drop-down. |
The filter appears as an input control when the view is used to run the report.
|
5.
|
Place your cursor over  , select Save Ad Hoc View as.... |
|
6.
|
Name the view, select a location, and click Save. |
|
7.
|
On the tool bar, click . |
Only the input controls defined in the topic appear here. Again, if no input controls were defined in the topic, the button appears inactive. You can create a report and open it in the report viewer to see a filter listed as an input control.
To edit the values for a view’s input controls:
|
1.
|
On the tool bar, click . |
A window listing the input controls defined in the Topic appears.
|
|
The Parametrized Report Topic already includes three input controls, created when the report was uploaded: Country, RequestDate, and OrderId.
|
|
2.
|
Select new values. For example, select USA from the Country drop-down. |
|
3.
|
To change default values of input controls, select the check box, Set these values as defaults when saving your view. |
The selected values become the default values when you save the view.
The Ad Hoc view shows USA data.
