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
-
In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reports.
-
Right-click the name of the report that you want to modify, and then click Properties.
-
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.
- Name: Specifies the name of the
report. The report name must be unique within the report
category.
-
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. - 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.
-
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.
- No Link: Specifies that a link is not
configured.
-
Click OK.