View / Explore SSRS Native Mode Report via PerformancePoint within SharePoint

If you are trying to develop BI reports within SharePoint.you will have more options to build magic reports, One of  this option is the Reporting Service (SSRS).

In SharePoint, you can use Reporting Service with Native Mode or SharePoint Integrated Mode based on your Manageability , Security, and Performance requirements.

If you are using SSRS with a Native Mode, you will need to configure the Report Viewer Web Part to view this reports within a SharePoint site as I mentioned before in this article

In this article, I will explain another method to can view SSRS Native Mode Report via PerformancePoint Dashboard designer within SharePoint by following the mentioned steps below:

Note:I assumed that the PerformancePoint ِApplication service has been configured

BICenter

  • Navigate to Site Content >  Dashboard Library > In PerformancePoint Tab Click on Dashboard Designer.

DashboardDesigner

  • The Dashboard Designer should be open > Right click on Performance Point Content > New > Report.

reports

  • Select Reporting Service Report , Click OK .

PPReprtingservicereport

  • Set Report Server Name & Report Name,Where the server name is the web service URL in SSRS Configuration Manager

reportcenter

To get Server Name

  • Open SSRS Configuration Manager

openSSRSConfigration

  •  From Web Service URL Copy the URL , Paste it In Server Name In PerformancePoint Dashboard

WebServiceURL

  • Click Browse To get your Report Name

browsrreports

  • 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.

addppwebpart

  •  Edit web part to add your report Path .

Uploadreport

  • Browse to PerformancePoint Content

inserppreport

  •  Click Report Name then OK,

you should now show a Native mode report within a SharePoint page.

Enjoy 🙂

Advertisements

3 thoughts on “View / Explore SSRS Native Mode Report via PerformancePoint within SharePoint

  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

    Like

    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.

      Like

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s