Filtering Data in a Model-Based Report (Report Builder 2.0)
In reports that use a report model as the data source, a filter allows you to limit the data displayed in your report to just the data that you are interested in viewing. Suppose you want to run a report that displays the sales for January, February, and March. You could create a report that lists all the sales and then group by the sales month, but you might have to look through hundreds of report pages to find the sales you are interested in. Applying a filter specifying January, February, and March will return only sales for those months.
In Report Builder 2.0, 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.
Filtering a report model data source differs from filtering other data source types. The query designer, functionality, and dialog boxes displayed are different than the query designers and dialog boxes that you may be used to working with when filtering data from other types of data sources.
For more information about creating and deploying report models see the "Working with Models" section of SQL Server Books Online.
In This Section
Topic |
Description |
|---|---|
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 2.0) |
Describes which comparison operators are available within a condition and between conditions. |
Specifying Criteria for a Filter Condition (Report Builder 2.0) |
Discusses the criteria in a filter condition and how to specify values. |
Discusses how to group filter conditions and nest a filter condition group within another filter condition group. |