FW: 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 RSWebParts.cab file can be found @
C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint
The stsadm.exe can be found here on a 2010 SharePoint install
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\BIN
in SharePoint 2007 the path should be like this below:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN
Cd to this directory and run this command
STSADM.EXE -o addwppack -filename "C:\Program Files\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall
The webparts are now available in SharePoint.
They show up under miscellaneous, when you try to add a web part
Official Reference: http://msdn.microsoft.com/en-us/library/ms159772.aspx
