Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

If you plan to use and integrate SQL Server Reporting Services to MOSS 2007, this add-in should work well.

The Microsoft add-in is described as:

Brief Description

The Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

Overview

Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies (Reporting Services Add-in) allows you to take advantage of SQL Server 2005 Service Pack 2 (SP2) report processing and management capabilities within Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. The download provides the following functionality:

A Report Viewer Web Part that provides report viewing capability, export to other rendering formats, page navigation, search, print, and zoom.

Web application pages so that you can create subscriptions and schedules, and manage reports, models, and data sources.

Support for using standard Windows SharePoint Services features including document management, collaboration, security, and deployment with report server content types.

The Reporting Services Add-in works together with SP2, which is required on the report server. SP2 provides the following functionality for a report server that is configured for SharePoint integrated mode:

Synchronization from SharePoint content database to the report server database.
A custom security extension that uses SharePoint permissions to control access to report server operations.

A new delivery extension that you can use in subscriptions to deliver reports to SharePoint libraries.

A revised Reporting Services Configuration tool that you can use to configure a report server for SharePoint integrated operations.

A new SOAP endpoint for managing report server content in SharePoint integrated mode.

You can download the add-in here.

1. 5 Shattering Mistakes for MOSS 2007 Newbie Developers and Team Leads, September 20, 2007 at 6:26 am

   [...] 3. Stand alone SSRS – if you have SQL Server tables, aspx pages, then you would need reports and normally SQL Reporting Services fit the bill. Unfortunately, since you have not developed your SharePoint skills, you end up creating a stand alone SSRS installation which does not integrate in MOSS using the SQL Server 2005 Reporting Services Add-in. [...]

Leave a Comment