Reporting Service Updates in SQL 2005 Service Pack 2

  • Article

 

SQL Server 2005 Service Pack 2 is coming out soon. The very important piece of SP2 is support of SSRS and SharePoint 2007 Integration. There are many bug fixes and enhancements in the service pack but here I want to highlight the integration with SharePoint 2007.

The key functionalities include:

SSRS & SharePoint Integration

The existing integration between Reporting Service and SharePoint are very limited. It is primarily done through two web parts – Report Explorer for listing the reports and Report Viewer for execution of the report. Security, Management of the UI and others are not integrated. In this coming Service Pack 2, SSRS not only starts to support SharePoint 2007 which is coming out before end of this year as part of Office 2007 product release, it also enhances the degree of the integrations.

  • Seamless integration with SharePoint Document Library in Office SharePoint Server 2007
    • Report server namespace and security is hosted in WSS content database
    • SharePoint database stores Report Server reports, data sources, models, resources etc.
    • Report Server database used for additional metadata (schedules, caching, subscriptions)
    • Enables collaboration, workflow, versioning
  • Centralized user interface for Report Management through Office SharePoint Server 2007
    • Upload, manage, render and deliver Reports all through Office SharePoint Server 2007 UI
    • Administration using Office SharePoint Server 2007
  • Rich reporting experience to "light up" Office SharePoint Server 2007
    • Filter web parts enhancing dashboards in Office SharePoint Server 2007

In SP2, Reporting Service also integrates with Hyperion, and Report Builder supports for Oracle Data Sources.