FilterValue Element (RDL)

Contains a value to compare to a filter expression.

Syntax

<FilterValues>
    ...
        <FilterValue>...</FilterValue>
    ...
</FilterValues>

Element Characteristics

Characteristic	Description
Data type and length	String
Default value	None
Cardinality	1-n: Required element that occurs once or more than once. For more information, see "Remarks."

Element Relationships

Relationship	Element
Parent element	FilterValues
Child element	None

Remarks

The FilterValue element contains an expression that evaluates to a variant or a variant array. It is compared to the value in the FilterExpression element using the value from the Operator element. (Both FilterExpression and Operator are siblings of the FilterValues element.)

The cardinality and value for the FilterValue element varies depending on the value of the Operator element.

Operator contains	Rule
Equal, Like, NotEqual, GreaterThan, GreaterThanOrEqual, LessThan, LessThanOrEqual	FilterValues must contain one and only one FilterValue element.
TopN, BottomN	FilterValues must contain one and only one FilterValue element. The value for FilterValue must evaluate to an integer.
TopPercent, BottomPercent	FilterValues must contain one and only one FilterValue element. The value for FilterValue must evaluate to an integer or float.
Between	FilterValues must contain exactly two FilterValue elements.
In	FilterValues can contain multiple FilterValue elements.

The FilterValue element cannot contain references to report items. When used in a dataset or data region, FilterValue cannot contain aggregate functions. When used in a grouping, FilterValue cannot contain the RunningValue or RowNumber function.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance