FilterValue Element (RDL)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
Contains a value to compare to a filter expression.
Datatype Characteristics
| Characteristic | Description |
|---|---|
Data type and length |
String |
Default value |
None |
Element Relationships
| Relationship | Element |
|---|---|
Parent elements |
|
Child elements |
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 Language XML Schema
Report Definition XML Elements
Concepts
Report Definition Language Data Types
Other Resources
Development (Reporting Services)
Filtering Data in a Report