Share via

  • Article

How to: Connect Filter or Documents Web Part (Reporting Services in SharePoint Integrated Mode)

If you are using Office SharePoint Server 2007, 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. 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.

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, click View All Site Content. In Libraries, click Documents. You can use the New, Upload, and Actions menu to manage the items in the Documents library.

To connect a Filter Web Part

  1. Open or create the Web Part page or dashboard.

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

  3. Click Add a Web Part.

  4. In All Web Parts, in the Miscellaneous section, select SQL Server Reporting Services Report Viewer.

  5. Click Add. The Web Part is added at the top of the zone.

  6. On another zone in the same Web Part page or dashboard, click Add a Web Part.

  7. In All Web Parts, in the Filters section, select a Web Part.

  8. Click Add. The Web Part is added at the top of the zone.

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

  10. Check in your changes and save the page.

To connect a Documents Web Part

  1. Open or create the Web Part page or dashboard.

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

  3. Click Add a Web Part.

  4. In All Web Parts, in the Lists and Library section, select Documents.

  5. Click Add. The Web Part is added at the top of the zone.

  6. Click Apply at the bottom of the tool pane, and then click OK to close the pane.

  7. On another zone in the same Web Part page or dashboard, click Add a Web Part.

  8. In All Web Parts, in the Miscellaneous section, select SQL Server Reporting Services Report Viewer.

  9. Click Add. The Web Part is added at the top of the zone.

  10. In the zone that contains the Web Part, click the Web Part edit menu, point to Connections, point to Get report definitions from, and then select Documents.

  11. Check in your changes and save the page.