Mailing List


Active Directory Products
Object Compare
Permission Compare

IPhone Products
Calls To Calendar
SMS To Gmail
Voicemail To Gmail

How Long For Me
My Music To Me


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

Attempted SQL Injection Attack
Restoring Specific Documents from a MOSS 2007 Content Database Backup
Using Multi-Value Parameters in SQL Server Reporting Services
Reading Digital Signatures from InfoPath Forms in MOSS 2007 and WSS 3.0 Workflow
Resolving "Tracing Service lost trace events" in MOSS 2007


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. DocuTerminal - Online Filing Cabinet solution. Scan, search and archive your paper documents. SaveMySerials - Protect yourself from theft, fire, natural disasters and more by recording your serial numbers My Music To Me - Stream your subsonic music collection to your Sonos wireless system TypeCount - Count how often you type across different computers! ServrTrackr - Monitor your SSL certificates, website uptime, and DNS configurations