Connect a Filter Web Part to a Report Viewer Web Part

If you are using Office SharePoint Server 2007, you can create a dashboard or Web Part Page that includes a Filter Web Part and a Report Viewer Web Part. By connecting the Web Parts, users who choose filter values in a Filter Web Part can view a report in an adjacent Report Viewer Web Part that shows related data.

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.

What do you want to do?

Add a Report Viewer Web Part

Add a Filter Web Part and define the connection

Add a Report Viewer Web Part

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

  2. On the Site Actions menu Button image , 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.

Top of Page

Add a Filter Web Part and define the connection

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

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

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

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

  5. Select the report parameter for which the Filter Web Part provides a value.

  6. Check in your changes and save the page.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×