...
- Open the View Properties dialog for a new or existing view.
- For new views in the Desktop client, right-click a service and select select Create View from from the pop-up menu.
- For new views in the web interface, open a service and select More Actions > Create View.
- For existing views in the Desktop client, right-click within the view and select select View Properties from from the pop-up menu.
- For existing views in the web interface, open the view and click the Properties button in the view toolbar.
- Enter a Name and Description (for new views).
- Select the Filters tab.
Enter a Service, Field, and Operator in the first line of the Filters statement.
Note You cannot use the In List, Is Blank, and Is Not Blank operators with a Prompt view.
- Click the Show Advanced button.
- Click the Prompt Wizard button.
- The first screen of the Prompt wizard displays with a message to select the prompt control type.
- The first screen of the Prompt wizard displays with a message to select the prompt control type.
- Select the List Box prompt type and click Next.
- Enter the values that you want to include in the drop-down list.
- Each value should appear in a separate row.
- After adding a value, press the down arrow key to add a blank row below the current row. Then, to add additional values, click within a blank row and enter the value.
- To delete a value, first select an existing row. Then right-click the row and select Remove Value from the pop-up menu.
- Click Next after you have added the list of values.
- Enter an optional default value, if desired.
- If you enter a default value, that value will be highlighted within the list box each time you run the view.
- If you enter a default value, that value will be highlighted within the list box each time you run the view.
- Edit the prompt caption, if desired.
- The default caption defaults to a combination of the filter's Field and Operator (such as "Name Exactly Matches"). This caption appears in the prompt view when the view is run.
- The default caption defaults to a combination of the filter's Field and Operator (such as "Name Exactly Matches"). This caption appears in the prompt view when the view is run.
- Click Finish to close the Prompt wizard.
- The wizard automatically populates the filter's Value field with the necessary SQL statement to generate the prompt box.
- The wizard automatically populates the filter's Value field with the necessary SQL statement to generate the prompt box.
- Click OK to close the View Properties dialog and run the view.
- In the list box prompt dialog, select a value from the list box, or make no change if you want to use the default value.
- Click OK to display the results of the view.
- To select a new value, refresh the view using one of the following methods:
...