Add Report Using Report Viewer Web Parts in SharePoint Foundation

In this article, you will see how to add a report using the report viewer web parts in SharePoint Foundation.

Step 1: First off all install the Report web parts in SharePoint, using:

Copy the RSWebParts.cab to a folder on the SharePoint server.
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint
Run Stsadm.exe on the .cab, using the following syntax:

STSADM.EXE -o addwppack -filename "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\SharePoint\RSWebParts.cab" -globalinstall

Step 2: Add a webpage in a SharePoint site.

Step 3: Now Edit in your Web Part.

Step 4: Add Report Manager and Report Path from your report server.

Report- Manager-in-Sharepoint.jpg

Report- Manager-url-in-Sharepoint.jpg

Step 5: Save the page.