Deploy reporting services web parts (RSWebParts) to SharePoint 2010

I had to do this the other day and here are the short and curlies of doing it.

If you have SQL 2008 installed the file can be found @
C:Program FilesMicrosoft SQL Server100ToolsReporting ServicesSharePoint

The stsadm.exe can be found here on a 2010 SharePoint install
C:Program FilesCommon FilesMicrosoft SharedWeb Server Extensions14BIN

Cd to this directory and run this command

STSADM.EXE -o addwppack -filename “C:Program FilesMicrosoft SQL Server100ToolsReporting” -globalinstall

The webparts are now available in SharePoint.
They show up under miscellaneous, when you try to add a web part

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.