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

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. (see : http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx and

5.0 Features in This Release (in english - french and...) :

1. This section summarizes the available features when you run a report server in SharePoint integrated mode.
2. Use the revised Reporting Services Configuration tool to create a report server database in SharePoint integrated mode.
3. Use the new report server configuration pages in Central Administration to grant the service accounts access to the SharePoint configuration and content databases.
4. Use SharePoint security to control access to report server content and operations.
5. Add reports and models that you created in SQL Server 2005 Reporting Services design tools to a SharePoint library. You can publish reports from Report Designer, or use the Upload action on a SharePoint library to upload any report server item. If you publish the files, be sure to specify fully qualified URLs.

An example URL for a file uploaded to Shared Documents on the top-level site of a SharePoint Web application might be :

http://example-server-name/Shared Documents/CompanySales.rdl.

The URL must include a file name extension.

If the library is on a site, you must also include any sites and subsites before the library.
---
For more information,
see "Deploying Reports, Models, and Shared Data Sources to a SharePoint Site" in SQL Server Books Online.
---
Create new shared data source (.rsds) files from a SharePoint site to use with the reports and models that you add to the library. A new file name extension named .rsds is introduced in this release; it is used for shared data source files that you create and store in a library.
Use the new Report Viewer Web Part to view reports.

Use Report Builder from a SharePoint site. You can open or modify an existing Report Builder report definition file from a library. You can load a model in Report Builder to create new reports from report model (.smdl) files that have been uploaded or published to a SharePoint library.

Use new Web pages and configuration options to set permissions and properties on reports (.rdl), models (.smdl), resources, and shared data sources (.rsds) that you add or create on a SharePoint site. You can also use Web application pages to define schedules and subscriptions.
---
Note:
Earlier versions of Reporting Services include two Web Parts that provide minimal integration between a report server and a SharePoint site.
Those Web Parts are not part of the Reporting Services Add-in and have different requirements and functionality.
---
For more information
about how those Web Parts compare with the Web Part that is included in the Reporting Services Add-in, see "Comparing Levels of Integration Across Versions of Reporting Services and SharePoint Technologies" in SQL Server Books Online.
http://www.microsoft.com/sql/default.mspx
---
SP2 SQL : Download Service Pack 2 for Microsoft SQL Server 2005.
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a
--
P. Erol GIRAUDY - MVP MOSS
www.clubmoss2007.org
www.shareclubs.org