This documentation is archived and is not being maintained.

Collation Element (RDL)

Describes the locale that the report server uses to sort data.


<DataSet Name="...">
    ...
    <Collation>...</Collation>
    ...
</DataSet>

Characteristic Description

Data type and length

String

Default value

None

Cardinality

0-1: Optional element that can occur once or not at all.

Relationship Element

Parent element

DataSet

Child element

None

The Collation element uses the standard SQL Server collation codes. For information about these codes, see Windows Collation Name (Transact-SQL).

If no collation is specified within the DataSet element, the report server attempts to derive the collation code from the data processing extension. If the server cannot get this information from the extension, the collation is set to the Language property of the report.

Show: