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.

Add-webpage-in-Sharepoint.jpg

insert-control-in-webpage-in-Sharepoint.jpg

Step 3: Now Edit in your Web Part.

Editl-in-webpart-in-Sharepoint.jpg

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

Report- Manager-in-Sharepoint.jpg

Report- Manager-url-in-Sharepoint.jpg

 Demo-Report-in-Sharepoint.jpg

Step 5: Save the page.