Reports in Configuration Manager 2007 retrieve data using a SQL statement. They can request information using a report prompt, link to another report or resource, and so on. The properties for a report are modified in the report properties dialog box. Use the following procedure to modify the properties for a report.

Procedure

To modify the general properties for a report

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports.

  2. Right-click the name of the report that you want to modify, and then click Properties.

  3. Click the General tab, and then modify any of the following general properties:

    • Name: Specifies the name of the report. The report name must be unique within the report category.

    • 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.

    • 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.

    • Click Prompts to create or modify a report prompt. For more information about creating report prompts, see How to Create or Modify Report Prompts.

  4. Click the Display tab, and then modify any of the following display properties:

    • Refresh the report automatically: Specifies whether to automatically refresh the data in the report. When it is enabled, specify the Refresh interval (minutes) setting. The default setting is 5 minutes.

    • Provide a chart for the report: Specifies whether to provide an option to display the results for the report in a chart. When it is enabled, specify the following settings:

      Default chart type: Specifies the default chart type from the drop-down list box. The chart will open with the chart type specified in the drop-down list, but it can be changed to another type when viewing the chart.

      Chart title: Specifies the name for the chart. This is an optional setting.

      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.

      Category [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.

      Category [Y] axis label: Specifies the label for the vertical axis (Y axis) of the chart.

    Note
    To display report data as a chart, you must have a licensed copy of Microsoft Office XP or Office 2000 Web Components installed on the reporting point site system. With Office XP, you also must have at least one Microsoft Office application installed on the reporting point site system.
  5. Click the Links tab, and then specify one of the following links properties:

    • No Link: Specifies that a link is not configured.

    • Link to another report: Specifies that a link to another report is configured. Click Select to specify the target report from the Select Report dialog box. If the target report requires prompts, you must specify the column from the source report that will be used to provide the data for each prompt in the target report. To configure the column, double-click a prompt, type the column number in the Column text box, and then click OK.

    • Link to Computer Details: Specifies that a link to computer details is configured. The source report must contain a column that contains the computer name. In the Computer name column text box, specify the column that contains the computer name and then click OK.

    • Link to Status Message Details: Specifies that a link to status message details is configured. The source report must contain a column that specifies a status message record ID. In the Record ID column text box, specify the column that contains the status record ID and then click OK.

    • Link to URL: Specifies that a link to a URL resource is configured. Specify the URL in the URL text box, and then click OK.

  6. Click OK.

See Also