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 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.
- Name: Specifies the name for the prompt.
- 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.