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.
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.
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.