Filtering Data in a Report (Report Builder 2.0)

In Reporting Services, you can filter report data before or after it is retrieved for a report. Report data is the set of datasets in the report. To filter data before it is retrieved, change the query for each dataset. When you filter data in the query, you filter data at the data source, which reduces the amount data that needs to be retrieved and processed in a report. To filter data after it is retrieved, create filter expressions in the report. You can set filter expressions for a dataset, a data region, or a group, including detail groups. You can also include parameters in filter expressions, providing a way to filter data for specific values or for specific users, for example, filtering on a value that identifies the user viewing the report.

When you include parameters that filter data, you have additional options that you can specify for a published report:

  • Linked reports   You can create linked reports with preset parameter values for different audiences. For more information, see Using Parameters to Connect to Other Reports (Report Builder 2.0).

  • Report subscriptions   You can specify parameter values or other criteria for subscriptions to published reports. For more information, see "Subscription and Delivery" in the Reporting Services documentation in SQL Server Books Online.

  • URL access   You can specify parameter values using URL access. For more information, see "Using Parameter Prefixes in a URL" in the Reporting Services documentation in SQL Server Books Online.

The method or combination of methods you choose depends on the capabilities of the data source, performance requirements, and your plan for report viewing after the report is published.

In This Section