FilterExpression Element (RDL)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Contains an expression that is evaluated for each row of data or group and compared to a filter value.

Datatype Characteristics

Characteristic Description

Data type and length


Default value


Element Relationships

Relationship Element

Parent elements

Filter Element (RDL)

Child elements



The FilterExpression element contains an expression that evaluates to a variant. The expression is evaluated for each instance within a group or for each row in a dataset or data region. It is compared to the values in the sibling FilterValues element using the operator from the sibling Operator element. Failed comparisons result in the instance or row being filtered out of the group, dataset, or data region.

The FilterExpression element cannot contain references to report items. When used in a dataset or data region, FilterExpression cannot contain aggregate functions, and when used in a group, it cannot contain the RunningValue or RowNumber functions.

See Also


Report Definition Language XML Schema
Report Definition XML Elements


Report Definition Language Data Types

Other Resources

Development (Reporting Services)
Filtering Data in a Report
Using Report Functions in Expressions (Reporting Services)

Help and Information

Getting SQL Server 2008 Assistance