The topics in this section provide real-world scenarios that demonstrate how to modify and clone predefined reports and how to create a new report, using different methods for creating or modifying the SQL statement in each report.

In This Section

Scenario 1: Modify an Existing Configuration Manager Report

Provides a real-world example of how to modify an existing report SQL statement to display the desired data.
Scenario 2: Clone an Existing Configuration Manager Report and Modify the SQL Statement in Query Designer

Provides a real-world example of how to clone an existing report and modify the SQL statement using Microsoft SQL Server 2005 Query Designer to display the desired data.
Scenario 3: Create a Report SQL Statement in Query Designer and Create a New Configuration Manager Report

Provides a real-world example of how to create a new report and modify the SQL statement using Query Designer to display the desired data.
Scenario 4: Create a Report SQL Statement in SQL Server Business Intelligence Development Studio and Create a New Configuration Manager Report

Provides an example of how to create a new report SQL statement in SQL Server Business Intelligence Development Studio and use the SQL statement when creating a new Configuration Manager 2007 report.

See Also