Edit

Connect Filter or Documents web part with a Reporting Services Report Viewer web part

  • Article

Applies to: ✅ SQL Server 2016 (13.x) Reporting Services and later ✅ Power BI Report Server ✅ SharePoint 2013 and later ❌ SharePoint Online

For content related to previous versions of SQL Server Reporting Services (SSRS), see SQL Server 2014 Reporting Services.

If you are using a SharePoint product, you can create a dashboard or web part Page that includes a Filter web part or Documents web part and a Report Viewer web part. Supported versions are SharePoint Foundation 2010 or SharePoint Server 2010. Also supported is Office SharePoint Server 2007. By connecting a Filter web part, users who select filter values in a Filter web part can send the value to a parameterized report on the same page. By connecting a Documents web part, users who click on reports in the Documents library can view the report in an adjacent Report Viewer web part.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

The Filter web part is used to send values to one or more parameters on a report. To use a Filter web part, the report must have parameters defined for it that are compatible with the values, data type, and format sent by the web part.

The Documents web part is associated with the Documents library of the Home site. To view, add, or remove items from the Documents library, select View All Site Content. In Libraries, select Documents. You can use the New, Upload, and Actions menu to manage the items in the Documents library.

Connect a Filter web part

  1. Open or create the web part page or dashboard.

  2. On the Site Actions menu, select Edit Page.

  3. Select Add a web part.

  4. In All web parts, in the Miscellaneous category, select SQL Server Reporting Services Report Viewer.

  5. Select Add. The web part is added at the top of the zone.

  6. On another zone in the same web part page or dashboard, select Add a web part.

  7. In All web parts, in the Filters section, select a web part.

  8. Select Add. The web part is added at the top of the zone.

  9. In the zone that contains the web part, select the web part edit menu, point to Connections, point to Send Filter Values To, and then choose Report Viewer - report name.

  10. Check in your changes and save the page.

Connect a Documents web part

  1. Open or create the web part page or dashboard.

  2. On the Site Actions menu, select Edit Page.

  3. Select Add a web part.

  4. In All web parts, in the Lists and Library section, select Documents.

  5. Select Add. The web part is added at the top of the zone.

  6. Select Apply at the bottom of the tool pane, and then choose OK to close the pane.

  7. On another zone in the same web part page or dashboard, select Add a web part.

  8. In All web parts, in the Miscellaneous category, select SQL Server Reporting Services Report Viewer.

  9. Select Add. The web part is added at the top of the zone.

  10. In the zone that contains the web part, select the web part edit menu, point to Connections, point to Get report definitions from, and then choose Documents.

  11. Check in your changes and save the page.

Related content

Add the Report Viewer web part to a web page
Report Viewer web part on a SharePoint Site
Customize the Report Viewer web part

More questions? Try asking the Reporting Services forum