Publishing Reporting Services reports to SharePoint in Native Mode

Reporting Services reports can be published to SharePoint using 2 modes, Native and SharePoint Integration Mode, here we shall see on how to publish a Reporting Services Report to a SharePoint Page in the Native mode.

1. To display reporting service reports in SharePoint in Native mode we need to install the Reporting Services web parts.

2. The setup files for installing the Reporting Services Web parts, will be available in the following path
       C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab  

3. Install the web parts using the following STSADM command.

          stsadm.exe -o addwppack -force –filename "C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab"

4. Create and publish the required report to the reporting server.

5. Edit the page where the report needs to be displayed, Click on Add Web Part.

6. Select Report Viewer Web Part

7. In the tools pane of the Web Part enter the full URL of the Report Manager and the Report File Path.

8. Apply the changes, save and Exit from the Edit mode.

9. Notice that the report gets displayed in the Web Part.

10. That’s it the reporting service report is now published to a SharePoint page using Native mode.