This is a great add in for those of us who build solutions around SharePoint and want to display reports inside of the portal.  Reports Center (feature of MOSS 2007) is great, and I there are a few other ways to display reports (including Excel Services, also a part of MOSS 2007), but a fully SharePoint-integrated Reporting Services Add-in would seem to be a "no brainer", and better yet it's FREE!

Here's the description of the Add-in (from the site):

The Microsoft SQL Server 2008 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.

Here's the overview of the Add-in:

Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 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.

This Reporting Services Add-in works together with SQL Server 2008 Reporting Services Release Candidate (RC0), which is required for the report server instance. SQL Server 2008 Reporting Services Release Candidate (RC0) provides the following functionality for a report server that runs in SharePoint integrated mode:
  • Synchronization from the SharePoint content database to the report server database.
  • A custom security extension that uses SharePoint permissions to control access to report server operations.
  • A 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 SOAP endpoint for managing report server content in SharePoint integrated mode.
  • Support for new data-driven subscriptions and URL parameters.
  • In-place upgrade of the Reporting Services Add-in.

Warning:
The Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) requires a SQL Server 2008 Reporting Services (SSRS) Release Candidate (RC0) instance. This add-in is not supported with earlier versions of SSRS.

Subscribe to Sheltonblog.com

↑ Grab this Headline Animator

 

Here's the download location: Click here

~Robert Shelton