Use the Column Values dialog box in Configuration Manager 2007 to select a value for a selected column that will be inserted into a SQL statement when creating the SQL statement for a report or report prompt.

The Column Values dialog box contains the following elements:

View

Specifies the highlighted view. This is a read-only setting.
Column

Specifies the highlighted column. This is a read-only setting.
Values

Specifies the values that are currently available for the highlighted view and column. Select a value from the list to insert into the SQL statement.
Values shown

Specifies the number of values that are available in the Values list.
Filter

Specifies whether a filter has been configured to limit the values that are displayed in the Values list.
Set

Opens the Set Filter dialog box, where a filter can be configured to limit the values that are displayed in the Values list. For more information, see Set Filter 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.

See Also