SortExpression Element (RDL)

Contains the expression by which to sort the data.

Syntax

<SortBy>
    ...
    <SortExpression>...</SortExpression>
    ...
</SortBy>

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

SortBy

Child element

None

Remarks

Only standard aggregate functions, like Sum, can be used in a sort expression.

References to report items cannot be used in a sort expression.

See Also

Reference

Report Definition XML Elements

Other Resources

Using Report Functions in Expressions (Reporting Services)

Help and Information

Getting SQL Server 2005 Assistance