Collation Element (RDL)

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

Syntax

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

Element Characteristics

Characteristic Description

Data type and length

String

Default value

None

Cardinality

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

Element Relationships

Relationship Element

Parent element

DataSet

Child element

None

Remarks

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.

See Also

Reference

Report Definition XML Elements

Help and Information

Getting SQL Server 2005 Assistance