Use the Prompts dialog box in Configuration Manager 2007 to specify the prompts in a report. Prompts are created to limit or target the data that a report retrieves. A report can contain more than one prompt as long as the prompt names are unique and contain only alphanumeric characters that conform to the SQL rules for identifiers. After a prompt is created in a report, it must be integrated into the SQL statement. For information about how to create a prompt and integrate it into the SQL statement, see How to Create or Modify Report Prompts.

The Prompts dialog box contains the following elements:


Displays the prompts that have been created for the report. The following prompt properties are displayed:
  • Name: Specifies the name for the prompt.

  • Prompt text: Specifies the prompt text that is displayed when the report runs.

  • Default value: Specifies the default value that is automatically inserted into the prompt text box when a report runs.

  • Allow an empty value: Specifies whether the prompt value is required or if it is optional.

  • Provide a SQL statement: Specifies whether a list of possible values will be retrieved for the prompt based on a SQL statement.

Create Object icon

Opens the Prompt Properties dialog box, where a new prompt is created.
Edit Object icon

Opens the Prompt Properties dialog box, where the properties for the prompt that is highlighted in the Prompts section is displayed and can be modified.
Delete Object icon

Deletes the prompt that is highlighted in the Prompts section. Prompts are permanently deleted when you click OK. To restore deleted prompts, click Cancel.
Report SQL statement

Displays the SQL statement for the report.

Saves the changes, and exits the dialog box.

Exits the dialog box without saving any changes.

Opens the help topic for this tab of the dialog box.

See Also