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.
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.
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
- 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.
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
- 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
- Link to URL: Specifies that this
report links to a URL resource. In the URL text box, type
the URL path.
Provides an update about the progress made in creating the
Provides a confirmation that the report was created
successfully. When the wizard fails to create a report, an error
will display on this page.