NerdyHearn
Home
Blog

Contact
Mailing List

Software

Active Directory Products
Object Compare
Permission Compare

IPhone Products
Calls To Calendar
SMS To CSV
SMS To Gmail
Voicemail To Gmail

Sites
DocuTerminal
How Long For Me
My Music To Me
SaveMySerials
TypeCount

Blog
Twitter

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\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.

Tags

SQL SharePoint Howto Reporting_Services

Related Blogs

Restoring Specific Documents from a MOSS 2007 Content Database Backup
Using Multi-Value Parameters in SQL Server Reporting Services
Attempted SQL Injection Attack
Using MOSS and WSS SharePoint Workflow to Resize Images in an Image Library

Comments

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

Name:


URL:


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


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