Topic Last Updated—August 2008

Microsoft Report Builder is the primary tool used in SQL Reporting Services in Configuration Manager 2007 R2 to construct reports. Report Builder allows the administrator to construct SQL Reporting Services reports by dragging items from views that have been exposed to the user through report models. When you use Report Builder, it is not necessary to understand where the data you are using is stored, making it possible for administrators with no experience in using SQL to construct reports.

Report Builder is launched automatically when you use the Create Report Wizard to create a model-based report. You can also open Report Builder from your SQL Reporting Services Web site.

This topic is an introduction to the features available in Report Builder. For detailed help and tutorials, refer to the documentation supplied with Report Builder.

The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

Features Available in Report Builder

Feature Description

Explorer pane

Allows you to easily view and choose from the available views and items.

Drag and drop

Drag available items into the report from the Explorer pane.

Interactive report building

Drag items around in the report design window, and position them wherever you want.


Apply filters to reports to limit the data based on criteria you specify.

Preview results

Generate an immediate preview of the report.

Adjust rows and columns

Interactively change the size of rows and columns in the report.

Export the report

Export the report in a variety of popular formats.

See Also