Jaa


Working with Filters (Report Builder)

Filtering 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 all the sales for yesterday's date. You could create a report that lists all the sales and then group by the sales date but you would probably have to look through thousands of report pages in order to find yesterday's sales. Applying a filter specifying yesterday's date will return only yesterday's sales.

In Report Builder, 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.

In This Section

Topic Description

Working with a Filter Condition (Report Builder)

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)

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

Specifying Criteria for a Filter Condition (Report Builder)

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

Grouping Filter Conditions (Report Builder)

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

See Also

Concepts

Working with Data (Report Builder)
Running a Report (Report Builder)

Other Resources

Report Builder F1 Help

Help and Information

Getting SQL Server 2005 Assistance