Integration Reporting Services with SharePoint 2007 in Native Mode

It is possible to integrate SQL Reporting Services with SharePoint 2007, but know the question is how you integrate it with SharePoint. The easiest why is to install the SharePoint Reporting Web Parts on your server. This is also called the Integration in Native Mode.

It isn’t more than installing the webpart and connect those webpart to an existing report that resist on you reporting server. But how do you install these webparts.
In the installation folder off SQL server there is a cab file with the two webparts. You can find this file (RSWebParts.cab) in the following folder:

C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab

After you found this file you can install it on your SharePoint Farm. To do this you have to navigate to the Application server of your SharePoint farm. Open a Command Prompt window and navigate to the folder that has the Stsadm.exe tool for SharePoint. Normally this path is C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN.

Run the Stsadm.exe tool and run it with the following syntax:

stsadm -o addwppack -filename “(Folder of the cab file)\RSWebParts.cab” -globalinstall

Adding web part and configuring the webpart

  • Open a Web Part page in your SharePoint Web Application
  • Set your page in edit mode: Site Action -> Edit Page, and click ‘Add a Web Part’ in the zone where you would like to add the Web Part.
  • In the Add Web Parts dialog box, scroll down to Miscellaneous. Select Report Explorer or Report Viewer if you want to add both Web Parts, and then click Add.
  • Know modify the settings of the Report Web Part. In Report Manager URL, type your URL to a Report Manager instance. By default, a Report Manager URL has the following syntax: http:///reports. For this setting you can also set the Start Path.

The Web Parts also allows you to connect the Report Explore to the Report Viewer. This connection can be set in the edit mode of the page:

  • Click on the edit button of the title bar of the Report Explorer Web Part
  • Point to Connections and follow that up by pointing to ‘Show report in’, and then click ‘Report Viewer’

Related Posts

Microsoft Office SharePoint Server 2007 on Windows Server 2008 R2 A few days ago I started setting up an internal development environment for SharePoint. This environment needed to exist of a Domain server, Database...
SharePoint 2007 Service Pack 2 Yesterday Service Pack 2 was released for SharePoint. In my post “Office Service Pack will be available on 28 April” you can read about some changes ...
February Cumulative Update Uber Package In my post a week ago I announced that the February Cumulative update was available for download but it could only be used by users who had the Decem...
February Cumulative Update The new cumulative update for Microsoft Office SharePoint Server 2007 and Windows SharePoint Services is available for you to apply to you server far...
Scheduling SharePoint Backup : Part 2 A while ago I posted a SharePoint Backup script so that it is possible to schedule a SharePoint Backup. I had to make some adjustments to the script b...
Scheduling SharePoint Backup Update:Version 2.0 available of the script here For one of our clients we had to schedule the SharePoint Backup what isn’t possible trough the interf...

Leave a Reply

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