How to show a Power View report at the SharePoint page (Silverlight Web Part)

How to show a Power View report at the SharePoint page (Silverlight Web Part)

转自：http://plexhosted.com/billing/knowledgebase/297/How-to-show-a-Power-View-report-at-the-SharePoint-page-Silverlight-Web-Part.html

• Synopsis

  This guide will show you how show a Power View report at the SharePoint 2013 page using Silverlight Web Part.

• Applicable to

  All PlexHosted accounts subscribed to SharePoint 2013 Business Intelligence plan.

• Prerequisite

  • a PlexHosted SharePoint 2013 Business Intelligence account
  • a PlexHosted SharePoint 2013 Business Intelligence site

• How to

  1. Login to the SharePoint 2013 site as an administrator.
  2. Navigate to the page on which you want to show your Power View report or create a new page.
  3. If you have created new page, go to the Insert tab and click onWeb Part. If want to add a Power View Report to the existing page, first check out this page, and click the Edit button on the ribbon.
  4. From the Media and Content category choose Silverlight Web Part and clickAdd.
  5. You will be prompted to enter the URL path for the Silverlight application. (That setting and address is also available when editing web part settings in the Application section when you click on the ‘Configure…’ button.) Enter the URL and clickOK. The URL path to the Silverlight application is the following:
     http://yourcompanydomain.com/_layouts/ReportServer/ClientBin/Microsoft.Reporting.AdHoc.Shell.Bootstrapper.xap
  6. SharePoint will load the Silverlight component. If it fails – no worries, there are several settings that need to be entered to make it work. Click on"Edit Web Part" from the Web Part drop down menu.
  7. Specify the title, height and width for the web part in the Appearance section.
  8. Under Other Settings click on the button with the ellipsis (...) near theCustom Initialization Parameters box.
  9. In the text editor enter the initialization parameters for your report. The initialization parameters have the following format:
     ItemPath=http://yourcompanydomain.com/yoursite/YourReport.rdlx,ReportServerUri=http://yourcompanydomain.com/_vti_bin/report
     We have used the following parameters in our web part:
     
     ItemPath=http://yourcompanydomain.com/PowerPivot%2520Gallery%2FPower%2520View%2520Report.rdlx,ReportServerUri=http://yourcompanydomain.com/_vti_bin/reportserver/,ViewMode=Presentation,ServerTraceLevel=1,AuthenticationMode=Windows,ReportSection=ReportSection
     
     
     Additionally, you can find these parameters if you open the "View Source" of the Power View editor in browser. There you can see the "InitParams" and the necessary parameters after it. (If you have used this method, make sure that you have replaced the encoded characters like %20 or %2F to the appropriate symbols – space, / etc.)
  10. Click Apply to make sure that your initialization parameters work and you can see the report.
  11. If everything works, click OK.
  12. Click on Save button either from Format Text tab or from the ribbon to save the changes on the page.
  13. Go to the Publish tab and click on Publish button.
  14. A publish window will pop up where you can add your comments. Click Continue.
  15. Now you can see the published page with your Power View report.

  If you need further assistance, please do not hesitate to contact us.

• Keywords

  SharePoint 2013, Enterprise, Business Intelligence, page, report, Power View, Silverlight Web Part, Report, show