Skip to content

Latest commit

 

History

History
47 lines (31 loc) · 3.04 KB

report-viewer-web-part-sharepoint-site.md

File metadata and controls

47 lines (31 loc) · 3.04 KB
Raw
title description author ms.author ms.date ms.service ms.subservice ms.topic ms.custom
Report Viewer web part on a SharePoint site - SSRS
Use the Report Viewer custom web part to view, navigate, print, and export SQL Server Reporting Services reports in a SharePoint site.
maggiesMSFT
maggies
02/11/2020
reporting-services
report-server-sharepoint
conceptual
updatefrequency5

Report Viewer web part on a SharePoint site - Reporting Services

[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016-and-later] [!INCLUDEssrs-appliesto-pbirsi] [!INCLUDEssrs-appliesto-sharepoint-2016-and-later] [!INCLUDEssrs-appliesto-not-sharepoint-online]

The Report Viewer web part is a custom web part. You can use the web part to view, navigate, print, and export reports on a report server within a SharePoint site. The Report Viewer web part is associated with report definition (.rdl) files that a Microsoft SQL Server Reporting Services report server processes.

The latest Report Viewer web part can also service paginated reports deployed to Power BI Report Server. The web part doesn't work with Power BI reports.

Why the Report Viewer web part is reintroduced

The Report Viewer web part was available as part of the Reporting Services Add-in for SharePoint products. The web part was specific for report servers in SharePoint integrated mode. SharePoint integrated mode was deprecated after SQL Server 2016.

Starting with SQL Server 2017, there's only one installation mode for Reporting Services: Native mode. You could embed all reports types using a Page Viewer web part using the rs:Embed=true URL parameter. Embedding reports into SharePoint pages is an integration story requested by customers and the updated Report Viewer web part enables this scenario for paginated reports.

While the Page Viewer web part suffices to embed a paginated report into a SharePoint page, the updated Report Viewer web part offers more features.

  • Show/hide specific toolbar buttons
  • Override report parameter values
  • Connect Filter web parts to report parameters

Download the Report Viewer web part solution package

The Report Viewer web part is available on the Microsoft Download Center.

Download Report Viewer web part solution package

Considerations and limitations

The items listed are specific to the updated Report Viewer web part.

  • The web part can only be used on classic SharePoint pages.
  • Only paginated (RDL) reports are supported for embedding in the Report Viewer web part. If you're looking to embed Power BI reports or mobile reports, you can use the rs:Embed=true URL parameter.

Related content

To get started with the updated Report Viewer web part, see Deploy the Report Viewer web part on a SharePoint site.