Designing and Implementing Reports Using Report Builder 2.0

Report Builder 2.0 is a report authoring environment for business users who prefer to work in the familiar Microsoft Office environment. You can use Report Builder 2.0 to work with data, define a layout, preview a report, and publish a report to a report server or SharePoint site. Report Builder 2.0 includes query builders and an expression editor. It also supports the advanced reporting features found in SQL Server 2008 Reporting Services.

You can use Report Builder 2.0 to create reports with multiple data regions (such as tables and charts), as well as data from multiple data sources within a single report. Report Builder 2.0 also supports queries that run directly against relational data sources and multidimensional data sources, as well as user-friendly data access via published report models.

With Report Builder, you can customize and update reports that were created in Report Designer or Report Builder 1.0. Report Builder 2.0 features easy-to-use wizards that walk you through the steps to create a simple table, matrix, or chart report.

In This Section