...
- Open the View Properties dialog for a new or existing view.
- For new views in the Desktop client, right-click a service and select Create View 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 View Properties 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.
Add a Service, Field, and Operator in the first line of the Filters statement.
Note You cannot use the In List, Is Blank, Is Not Blank operators with a Prompt view.
- Click the Prompt Wizard button.
- In the Prompt Wizard dialog, select the Drop Down (SQL Query) prompt type and click Next.
- In the Select SQL Query field, enter the name of the desired view prompt query.
- If you want a caption to appear in the dialog for your prompts, enter a caption in the Enter a prompt caption field.
- 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.
- In the Create View screen, click OK to close the screen and run the view.
- A tab for this view is created.
- A tab for this view is created.
- In the tab for this view, go to the prompt caption drop down list box and select a value from the list or manually enter a value to view.
- Click GO to display the results for your selection.
- To select a new value, repeat steps 12 and 13.