SortExpression Element (RDL)

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Contains the expression by which to sort the data.

Datatype Characteristics

Characteristic Description

Data type and length

String

Default value

None

Element Relationships

Relationship Element

Parent elements

NIB - SortBy Element (RDL)

Child elements

None

Remarks

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

Aggregate functions are evaluated using the default scope defined in the SortExpressionScope element. You can also specify a scope parameter for the aggregate function, but it must be equal to or contain the SortExpressionScope.

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

See Also

Reference

Report Definition XML Elements
Report Definition Language XML Schema
Report Definition XML Elements

Concepts

Report Definition Language Data Types

Other Resources

Using Report Functions in Expressions (Reporting Services)
Development (Reporting Services)
Sorting Data in a Report

Help and Information

Getting SQL Server 2008 Assistance