Show SSRS Report in SharePoint 2013

In this article, we’ll explain how to Show SSRS Report in SharePoint 2013 and SharePoint 2016.


Show SSRS Report in SharePoint 2013

SharePoint provides you many options to develop BI reports, one of theses options is using SQL Server Reporting Service (SSRS).

In SharePoint, you can use Reporting Service with Native Mode or SharePoint Integrated Mode. If you are using SSRS with a Native Mode, you will need to configure the Report Viewer Web Part to view these reports within a SharePoint site as I mentioned in Install and configure the Reporting Service Web Part In SharePoint 2013.

Here, we will explain another method to show SSRS Native Mode Report using PerformancePoint Dashboard designer in SharePoint by following the mentioned steps below:

Steps

  • Navigate to your BI Center Site.
BI Center in SharePoint
  • Navigate to Site Content >  Dashboard Library > In PerformancePoint Tab Click on Dashboard Designer.
PerformancePoint Dashboard Designer in SharePoint
  • The Dashboard Designer should be open.
  • Right click on Performance Point Content > New > Report.
Create a new PerformancePoint Report in SharePoint
  • Select Reporting Service Report , Click OK .
Show SSRS Report in SharePoint 2013

Note: You may get this issue Failed to load the appropriate report editor in PerformancePoint Dashboard Designer.

  • Set Report Server Name & Report Name, where the server name is the web service URL in SSRS Configuration Manager
Show SSRS Report in SharePoint 2016

Get Reporting Service Server name

  • Open SSRS Configuration Manager
open SSRS Configuration Manager
  •  From Web Service URL Copy the URL , Paste it In Server Name In PerformancePoint Dashboard
Get Reporting Service Server name
  • Click Browse To get your Report Name
browse PerformancePoint Reports in SharePoint
  • Save your Report and navigate to your page that you need to show your report within it.
  • Click edit Page > Add Web Part >  PerformancePoint Section > PerformancePoint Report > Click Add.
PerformancePoint web part in SharePoint
  •  Edit web part to add your report Path .
show PerformancePoint Reports in SharePoint
  • Browse to PerformancePoint Content
add PerformancePoint Report in SharePoint
Show SSRS Report in SharePoint 2013
  •  Click Report Name then OK,
  • You should now show a Native mode report within a SharePoint page.

Conclusion

In conclusion, we have learned how to show SSRS report in SharePoint 2013 using PerformancePoint Dashboard Designer.

Applies To
  • SharePoint 2013
  • SharePoint 2016

See Also

3 thoughts on “Show SSRS Report in SharePoint 2013”

  1. Dear Mohammed,

    I have sharepoint 2007 project running as production. i want to move all project to test server.
    i installed sharepoint 2007 on test server and create web application and site collection. what is the next step to move all files,databases to run this project in test server..
    best regards.
    Haroun

    1. Dear Haroun
      Only what you need to restore your production farm is to specify what’s the build number version & CU updates that you already installed in production server next try to make the build version of test server identical to production server then get farm backup and restore it.
      It’s will restore the configuration and content for your farm from production to test without any problem.
      for any help & more discussion don’t hesitate to reply on me, you can also open team viewer to help you.

  2. Pingback: Failed to extract the cab file in the solution SQL Server 2012 SP1 Reporting Services Web Parts cabinet file | Errors - Problems (SharePoint - ASP.Net - SQL Server .... etc)

Leave a Reply