• Article

Report Builder 3.0

Microsoft SQL Server Reporting Services Report Builder 3.0 is a report authoring tool that features a Microsoft Office-like authoring environment and new features such as new sparkline, data bar, and indicator data visualizations, the ability to save report items as report parts, a wizard for creating maps, aggregates of aggregates, and enhanced support for expressions. For more information about new features in Report Builder 3.0, see What's New in Report Builder 3.0 in Report Builder 3.0 Help on msdn.microsoft.com.

Table, Matrix, Chart, and Map wizards

Easy-to-use wizards walk you through the steps of creating a table, matrix, chart, or map on your report. Steps to create a table, matrix, or chart include

  • Adding a connection to a data source.

  • Creating or importing a dataset.

  • Arranging fields.

  • Choosing a layout or a chart type.

  • Choosing a preliminary style.

With the Map Wizard and Map Layer Wizard, you can add maps and map layers to your report to help visualize data against a geographic background.

Use the wizards as a starting point for creating a data region that you can continue to modify after you've finished the wizard.

Modify Reports from Other Environments

You can customize and update all existing reports, regardless of where they were initially designed. Thus, your organization can create more advanced reports within Microsoft SQL Server Business Intelligence Development Studio and distribute them to end users, who can customize them in Report Builder to meet their needs. You can also update reports created in previous versions of Report Builder.

Multiple Data Regions and Data Sources

Full support for all of the capabilities of Report Definition Language (RDL) means that you can use Report Builder 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 also supports queries that run directly against relational data sources (SQL Server, Oracle, Teradata, OLE DB, and ODBC) and multidimensional data sources (SQL Server Analysis Services, Oracle, Hyperion Essbase, SAP NetWeaver BI). Report Builder also supports user-friendly data access via published report models (SMDL) based on SQL Server, SQL Server Analysis Services, Oracle, and Teradata.