Install and configure the Reporting Service Web Part In SharePoint 2013

In this article, I will solve the below issue

Missing Report Viewer Web Part in SharePoint 2013


Scenario

When I tried to use a Report Viewer Web Part inside SharePoint page to display a native mode reporting service report.

Unfortunately, I could not find the Report Explorer and Report Viewer web part.

addreportviwer

I have SharePoint 2013, SQL Server 2012 R2 SP1.


Cause:

By default, In SharePoint, the Report Viewer and Report Explorer WebParts are not installed, you need to configure it.


Install and configure the Reporting Service web part In SharePoint 2013.

To find the Report Viewer and Report Explorer Web Part in SharePoint, you should install “SPViewer.dwp that exists inside “RSWebParts.cab“.

Steps

  • Locate the below path.
C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Reporting Services\
SharePoint
  • Find the “RSWebParts.cab in the above path.
  • Copy this file to a local temp folder in SharePoint server.
  • Open SharePoint Management Shell as Administrator.

Run CA as Adminstrator

  • Install “RSWebParts.cab via the below cmdlet.

Install-SPWebPartPack -LiteralPath "C:\Temp\RSWebParts.cab" -GlobalInstall

Unfortunately, I got the following error! 

Failed to extract the Reporting Services web part cab file. in the solution.

Failed to extract the Reporting Services web part cab file. in the solution.

To overcome this issue, 

  • Copy the same file from another environment that running the “Reporting Service with SQL server 2008 R2” that located in the below path:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Reporting Services\
SharePoint\RSWebParts.cab
  • Drop this file into a local temp folder in the destination SharePoint server.
  • Again, try to run the previous cmdlet via SharePoint Management Shell.
 Install-SPWebPartPack -LiteralPath "C:\Temp\RSWebParts.cab" -GlobalInstall 
  • This should be now worked properly.

Install and configure the Reporting Service web part In SharePoint 2013.

  • Go back to edit the SharePoint page > Add a web part > Miscellaneous section > you should now discover the new following two report web part:
    • Report Viewer.
    • Report Explorer.

Missing Report Viewer Web Part in SharePoint 2013


How to configure the Report URL in the Report Viewer web part.

  • Open the page is in edit mode.
  • Click Edit Web Part in the Report Viewer Web Part.
  •  In Report Manager URL, type a URL to a Report Manager instance that is associated with the native mode report server that you want to access.

By default, a Report Manager URL has the below syntax: http://servername/reports.

  • In the Report Path, specify a forward slash, followed by the folder path, and the report name.

Do not include the server name or Report Manager virtual directory.

Examples:

Consider you have a report called ‘Company Sales’ in the “Adventure Works” folder, so the URL should be specified as the following:

 /Adventure Works/Company Sales.

If you have a report called ‘Products’ is in the report server root “Home” folder, so the URL should be

/Products.


Applies To
  • SharePoint 2013.
See also

How to explore a Native Mode Report using PerformancePoint Report viewer

Advertisements

6 thoughts on “Install and configure the Reporting Service Web Part In SharePoint 2013

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s