Filtering Data in a Report

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:

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.

Filtering Report Data at the Source

Discusses filtering data for a dataset at the data source, before it is retrieved for the report.

Filtering Report Data in the Report

Discusses filtering data in a report after it has been retrieved from the data source.

Filtering Data in a Model-Based Report

Discusses filtering data in a report that uses a report model as a data source.

Filter Equation Examples (Reporting Services)

Provides examples of different types of filter equations.

Community Additions