Use the Prompt SQL Statement dialog box in Configuration Manager 2007 to specify the SQL statement for a specified prompt in the report. When the prompt displays and the user clicks Values, Configuration Manager retrieves a list of values from the site server database using the configured SQL statement for the prompt.
The Prompt SQL Statement dialog box contains the following elements:
- Views
- Displays the Configuration Manager SQL views that can be added to the SQL statement. To insert a view into the SQL statement, click the location to insert the SQL view within the SQL statement, select the view from the Views list, and then click Insert.
- Columns
- Displays the columns for a view that is highlighted in the Views list. To add a filter to the SQL statement with a column value, click the location to insert the SQL view within the SQL statement, select the view from the Views list, select the column from the Columns list, and then click Values. Choose the values from the Column Values dialog box and click OK.
- SQL statement
- Specifies the SQL statement for the prompt. The SQL statement can be modified within the text box, views and column values can be added to the SQL statement by using the Views and Columns lists, or the SQL statement can be modified by using Query Designer in SQL Server 2005. For more information, see How to Use Query Designer to Create or Modify Report Queries and SQL Query Statement Reference.
- Insert
- Specifies that the SQL view highlighted in the Views list is inserted into the SQL statement at the last position of the cursor. The SQL view is inserted at the start of the SQL statement if the cursor position was not selected.
- Values
- Opens the Column Values dialog box, where a value for the column highlighted in the Columns list can be selected. For more information about selecting a column value, see Column Values Dialog Box.
- OK
- Saves the changes, and exits the dialog box.
- Cancel
- Exits the dialog box without saving any changes.
- Help
- Opens the help topic for this tab of the dialog box.