Use the New Report Wizard in Configuration Manager 2007 to create a new report. The user creating a report must have Create permission for the Reports security object class and a working knowledge of SQL. The New Report Wizard contains the pages and associated elements as described in the following table.

Name Description

General Page

Configure the following report settings:

  • Name: Specifies the name for the report. The report name is required and must be unique.

  • Category: Specifies the category for the report. Categories are case sensitive and, unless a new category is being created for the report, it is recommended that the category be selected from the Category drop-down list. If the category name is entered so that it is not identical to the name in the drop-down list, a new category will be created.

  • Display in Computer Details: Specifies whether the report will appear on the Computer Details page of Report Viewer. This setting is available only to reports that have one or no report prompts configured.

  • Comment: Specifies a description for the report. This is an optional field that helps to describe the purpose of the report.

  • SQL statement: Specifies the SQL statement used to retrieve the report data. Click Edit SQL Statement to modify the SQL statement.

  • Edit SQL Statement: Opens the Report SQL Statement dialog box, where the SQL statement can be modified and report prompts can be created or modified.

Display Page

Configure the following report settings:

  • Refresh the report automatically: Specifies whether the data in a report is automatically refreshed by running the report query at a configured interval. When this element is enabled, configure the following setting:

    • Refresh interval: Specifies the number of minutes between automatic updates. The refresh interval can be configured to be from 1 to 60 minutes.

  • Provide a chart for the report: Specifies whether a chart is created that can be displayed when the report is run. When this element is enabled, configure the following settings:

    • Default chart type: Specifies the default chart type that is displayed when the chart is opened. The available chart types are Column, Bar, Line, Area, Pie, Exploded Pie, Doughnut, Exploded Doughnut, and Scatter (X,Y). After the chart opens, a different chart type can be specified.

    • Chart title: Specifies the title displayed above the chart.

    • Category (X) axis column: Specifies the column number from the report that is used for the data that is presented along the horizontal axis (X axis) of the chart.

    • Category (X) axis label: Specifies the label for the horizontal axis (X axis) of the chart.

    • Value (Y) axis column: Specifies the column from the report that is used for the data that is presented along the vertical axis (Y axis) of the chart.

    • Value (Y) axis label: Specifies the label for the vertical axis (Y axis) of the chart.

Links Page

Configure the Link Type for the report, which specifies whether there is a link to a target resource. The following link types and associated properties are available:

  • No link: Specifies that this report does not link to a target resource.

  • Link to another report: Specifies that this report links to another report. The following properties must be configured:

    • Report: Specifies the target report. Click Select, choose from one of the reports in the Select Report dialog box, and then click OK.

    • Prompts: Specifies the prompts that are configured for the target report. Double-click a prompt, select the column number from this report that contains the data for the prompt, and then click OK.

  • Link to Computer Details: Specifies that this report links to the Computer Details page that provides more information about a specific computer. In the Computer name column text box, type the column number from this report that contains computer names.

  • Link to Status Message Details: Specifies that this report links to the Status Message Details page that provides more information about a specific status message. In the RecordID text box, type the column number from this report that contains the record ID value for status messages.

  • Link to URL: Specifies that this report links to a URL resource. In the URL text box, type the URL path.

Progress

Provides an update about the progress made in creating the report.

Confirmation

Provides a confirmation that the report was created successfully. When the wizard fails to create a report, an error will display on this page.

See Also