What's New (Reporting Services)

Microsoft SQL Server 2008 Reporting Services (SSRS) introduces many new features and enhancements that increase the reporting capabilities of people who develop reporting solutions.

What's New in Report Authoring

Introduces tablix, chart, and gauge data regions. It also introduces support for richly formatted text, new data source types, and Report Builder 2.0, which offers many new features, like enhanced data layout and visualization, in an Office-like authoring environment. Finally, this topic describes incremental changes to authoring tools and the Report Definition Language (RDL) that allow a report author to take full advantage of new processing features.

Important noteImportant

Service Pack 1 (SP1) provides a ClickOnce version of Report Builder 2.0.

What's New in Report Processing and Rendering

Introduces new rendering extensions for Microsoft Word and enhancements to the Excel and CSV rendering extensions. This topic also describes important changes to the report processor that improve the performance and scalability of large reports.

What's New in Server Architecture and Tools

Introduces the new report server architecture that includes native support for functionality previously provided by Internet Information Services (IIS).

What's New in Report Programmability

Introduces a new server extension that provides preprocessing for report definitions, plus new methods to the ReportServer2006 endpoint that eliminate the feature gap that previously existed between native mode and SharePoint integrated mode report servers.

SQL Server 2008 SP2 provides updates for Reporting Services SharePoint integration. SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. SQL Server 2008 SP2 also provides a new add-in for SharePoint 2007 products. The new add-in supports the integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.

Summary of SQL Server 2008 SP2 Updates

Updated component

New functionality

SQL Server 2008 SP2 report server.

Integration with SharePoint 2010 products

SQL Server 2008 SP2 add-in for SharePoint 2007 Products.

Integration of SharePoint 2007 products with SQL Server 2008 R2 report servers.

Updated report server will integrate with SharePoint 2010 products

SQL Server 2008 SP2 report servers can integrate with SharePoint 2010 products. The SharePoint features supported by the SQL Server 2008 SP2 Reporting Services integration are the same features supported when integrated with SharePoint 2007. Feature support is also dependent on SharePoint 2010 backward compatibility support. Consult your SharePoint documentation for backward compatibility information.


SharePoint features that are new in SharePoint 2010, such as Claims Authentication, are not supported.

For more information about integrating SQL Server 2008 SP2 with SharePoint 2010 products, see Integrating SQL Server 2008 SP2 Report Servers with SharePoint 2010.

Updated add-in for integrating SharePoint 2007 with SQL Server 2008 R2 report servers

The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint 2007 lets you integrate SharePoint 2007 products with SQL Server 2008 R2 report servers and use some of the new SQL Server 2008 R2 features. The new features supported include the following:

  • Support for Report Part Gallery, shared datasets, and shared report items.

  • SQL Server 2008 R2 Report Builder 3.0.

  • ATOM feed renderer. For more information, see the “Rendering Reports to Data Feeds” section in What's New (Reporting Services).

For more information about how to use the add-in for SharePoint products, see Reporting Services Add-in Supports Integrating SQL Server 2008 R2 Report Servers with SharePoint 2007.

Updated content

Added a section describing changes for the SQL Server 2008 Service Pack 2 release.