Mailing List



NerdyHearn - Blog

<< Back To All Blogs

Deploying Reporting Services WebParts to SharePoint WSS and MOSS

Thursday, September 24th, 2009

SharePoint does not natively have the web parts available to display Reporting Services reports within web parts, but this can be easily fixed.

There is a WebPart Pack that ships with the reporting services installation which can easily be deployed to SharePoint.

For Reporting Services 2008, this pack is available here: C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\

If your SharePoint server is on a different server then Reporting Services, make sure to copy to a local location on the SharePoint server in which you plan to install the web parts.

Then, to install the web parts, execute the following command on your SharePoint Server:

STSADM.EXE -o addwppack -filename "C:\path\to\cab\" -globalinstall

This will install and enable both the Report Viewer web part and the Report Browser web part.

When adding a web part to a page, they will be available under the Misc section.

Pretty simple, but had to do some digging to find this one.

SharePointReportin' Tom Out.


SQL SharePoint Howto Reporting_Services

Related Blogs

Using Multi-Value Parameters in SQL Server Reporting Services
Restoring Specific Documents from a MOSS 2007 Content Database Backup
Attempted SQL Injection Attack
Fixing MOSS/WSS SharePoint errors with Alternate Access Mappings
Configuring ASP.NET (And SharePoint) to use SQL-based Sessions


Craig Humphrey said on Monday, September 28th, 2009 @ 2:35 AM

I think that's why most people use the separate installer:

It also pays to read the SSRS installation instructions, as even with a SharePoint integrated install of SSRS, you can have some fun.

Add A Comment



Email Address: (not public, used to send notifications on further comments)


Enter the text above, except for the 1st and last character:

NerdyHearn - Latest tech news relating to C#, ASP.NET, SharePoint, PHP, general development, and more. SaveMySerials - Protect yourself from theft, fire, natural disasters and more by recording your serial numbers