FilterExpression Element (RDL)

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

Syntax

<Filter>
    ...
        <FilterExpression>...</FilterExpression>
      ...
</Filter>

Element Characteristics

Characteristic Description

Data type and length

String

Default value

None

Cardinality

1-1: Required element that occurs once and only once.

Element Relationships

Relationship Element

Parent element

Filter

Child element

None

Remarks

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 grouping, 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 grouping, it cannot contain the RunningValue or RowNumber functions.

See Also

Reference

Report Definition XML Elements
Operator Element (RDL)
FilterValues Element (RDL)

Help and Information

Getting SQL Server 2005 Assistance