Working with Filters (Report Builder 1.0)
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.
Discusses how to select the field that you want to use in a filter condition.
Describes which comparison operators are available within a condition and between conditions.
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.