Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

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.

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.