How to Create a New SQL-Based Report in SQL Reporting Services
Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3
Use the Create Report Wizard in Configuration Manager 2007 R2 SQL Reporting Services to create a new SQL-based report.
The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.
To create a new SQL-based report
In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.
Right-click the report server name, and select Create Report.
If you right-click a report folder and click Create Report, the report will be created in that report folder.
On the Information page of the Create Report Wizard, select SQL-based report, and then specify the following information:
Name—Specify a descriptive name for this report.
Description—Specify an optional description for this report.
Path—Specify the report folder in which this report will be stored.
Click Next to Continue.
On the Create datasets page of the wizard, specify the following information:
Dataset Name—From the drop-down list, select an existing dataset to use for this report or click the New button to create a new dataset.
A dataset contains the SQL query that you want to use in the report. A report can use many datasets, but it must use at least one.
Timeout—Specify the time in seconds after which processing of this query will fail if data cannot be retrieved from the data source. The default value is 30 seconds.
Display dataset on report—Select this box to display the results of this dataset in the report.
To edit the properties of the selected dataset, click the Edit Command Text button. In the Command Text dialog box, specify the SQL query to be used by this report. When you are finished, click OK to close the Command Text dialog box.
If you want this report to use parameters—for example, if you would like the report to prompt for a Configuration Manager 2007 collection to restrict the report results—click the Report Parameters button. In the Report Parameters dialog box, specify the parameters to be used by this report. When you are finished, click OK to close the Report Parameters dialog box.
Click Next to continue.
On the Summary page of the wizard, review the actions to be taken and then click Next.
After the report is created, the Wizard Completed page is displayed. Review the results from the wizard and then click Close.
You might need to refresh the display in the Configuration Manager console before the new report is visible.
For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.