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