<< 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\RSWebParts.cab.
If your SharePoint server is on a different server then Reporting Services, make sure to copy RSWebParts.cab 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\RSWebParts.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.
Restoring Specific Documents from a MOSS 2007 Content Database Backup
Using Multi-Value Parameters in SQL Server Reporting Services
Attempted SQL Injection Attack
Configuring ASP.NET (And SharePoint) to use SQL-based Sessions
Fixing "Error in loading DLL" in SharePoint
Craig Humphrey said on Monday, September 28th, 2009 @ 2:35 AM
I think that's why most people use the separate installer: http://www.microsoft.com/downloads/details.aspx?FamilyID=58edd0e4-255b-4361-bd1e-e530d5aab78f&displaylang=en
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: