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