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 the following topics in the Reporting Services documentation in SQL Server Books Online:
Topic |
Description |
|---|---|
"Working with a Filter Condition" |
Discusses how to select the field that you want to use in a filter condition. |
"Selecting a Comparison Operator for a Filter Condition" |
Describes which comparison operators are available within a condition and between conditions. |
"Specifying Criteria for a Filter Condition" |
Discusses the criteria in a filter condition and how to specify values. |
"Grouping Filter Conditions" |
Discusses how to group filter conditions and nest a filter condition group within another filter condition group. |
See Also
Concepts
Filtering Report Data at the Source
Filtering Report Data in the Report