Filtering Data in a Model-Based Report

In reports that use a report model as the data source, a filter is a set of conditions that are applied to the data at the data source level. Therefore, only the data that meets these conditions is included in the report. The rest of the report data is still available in the underlying database; it is just not included in the rendered report.

Filtering a report model data source differs from filtering other data source types. The functionality and dialog boxes displayed are different than the dialog boxes you may be used to working with when filtering other types of data sources.

For more information about how to filter data in model-based reports, see:

Topic

Description

Working with a Filter Condition (Report Builder 1.0)

Discusses how to select the field that you want to use in a filter condition.

Selecting a Comparison Operator for a Filter Condition (Report Builder 1.0)

Describes which comparison operators are available within a condition and between conditions.

Specifying Criteria for a Filter Condition (Report Builder 1.0)

Discusses the criteria in a filter condition and how to specify values.

Grouping Filter Conditions (Report Builder 1.0)

Discusses how to group filter conditions and nest a filter condition group within another filter condition group.