SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Reporting Services Programming
Report Definition Language
Report Definition XML Elements
AccentSensitivity Element (RDL)
Action Element (RDL)
AllowBlank Element (RDL)
AltReportItem Element (RDL)
Author Element (RDL)
AutoRefresh Element (RDL)
Axis Element (RDL)
BackgroundColor Element (RDL)
BackgroundGradientEndColor Element (RDL)
BackgroundGradientType Element (RDL)
BackgroundImage Element (RDL)
BackgroundRepeat Element (RDL)
Body Element (RDL)
Bookmark Element (RDL)
BookmarkLink Element (RDL)
BorderColor Element (RDL)
BorderStyle Element (RDL)
BorderWidth Element (RDL)
Bottom Element (BorderColor) (RDL)
Bottom Element (BorderStyle) (RDL)
Bottom Element (BorderWidth) (RDL)
BottomMargin Element (RDL)
Calendar Element (RDL)
CanGrow Element (RDL)
CanShrink Element (RDL)
Caption Element (RDL)
CaseSensitivity Element (RDL)
CategoryAxis Element (RDL)
CategoryGrouping Element (RDL)
CategoryGroupings Element (RDL)
CellDataElementName Element (RDL)
CellDataElementOutput Element (RDL)
Chart Element (RDL)
ChartData Element (RDL)
ChartElementOutput Element (RDL)
ChartSeries Element (RDL)
Class Element (RDL)
Classes Element (RDL)
ClassName Element (RDL)
Clustered Element (RDL)
Code Element (RDL)
CodeModule Element (RDL)
CodeModules Element (RDL)
Collation Element (RDL)
Color Element (RDL)
ColSpan Element (RDL)
ColumnGrouping Element (RDL)
ColumnGroupings Element (RDL)
Columns Element (RDL)
ColumnSpacing Element (RDL)
CommandText Element (RDL)
CommandType Element (RDL)
ConnectionProperties Element (RDL)
ConnectString Element (RDL)
Corner Element (RDL)
CrossAt Element (RDL)
Custom Element (RDL)
CustomData Element (RDL)
CustomProperties Element (RDL)
CustomProperty Element (RDL)
CustomReportItem Element (RDL)
DataCell Element (RDL)
DataCollectionName Element (RDL)
DataColumnGroupings Element (RDL)
DataElementName Element (RDL)
DataElementOutput Element (RDL)
DataElementStyle Element (RDL)
DataField Element (RDL)
DataGrouping Element (RDL)
DataGroupings Element (RDL)
DataInstanceElementOutput Element (RDL)
DataInstanceName Element (RDL)
DataLabel Element (RDL)
DataPoint Element (RDL)
DataPoints Element (RDL)
DataProvider Element (RDL)
DataRow Element (RDL)
DataRowGroupings Element (RDL)
DataRows Element (RDL)
DataSchema Element (RDL)
DataSet Element (RDL)
DataSetName Element (DataSetReference) (RDL)
DataSetName Element (Data Regions) (RDL)
DataSetReference Element (RDL)
DataSets Element (RDL)
DataSource Element (RDL)
DataSourceName Element (RDL)
DataSourceReference Element (RDL)
DataSources Element (RDL)
DataTransform Element (RDL)
DataType Element (RDL)
DataValue Element (RDL)
DataValues Element (RDL)
Default Element (BorderColor) (RDL)
Default Element (BorderStyle) (RDL)
Default Element (BorderWidth) (RDL)
DefaultValue Element (RDL)
DepthRatio Element (RDL)
Description Element (RDL)
DetailDataCollectionName Element (RDL)
DetailDataElementName Element (RDL)
DetailDataElementOutput Element (RDL)
Details Element (RDL)
Direction Element (RDL)
Direction Element (Style) (RDL)
DrawingStyle Element (RDL)
Drillthrough Element (RDL)
DynamicCategories Element (RDL)
DynamicColumns Element (RDL)
DynamicRows Element (RDL)
DynamicSeries Element (RDL)
EmbeddedImage Element (RDL)
EmbeddedImages Element (RDL)
Enabled Element (RDL)
Field Element (RDL)
Fields Element (RDL)
Filter Element (RDL)
FilterExpression Element (RDL)
Filters Element (RDL)
FilterValue Element (RDL)
FilterValues Element (RDL)
FixedHeader Element (RDL)
FontFamily Element (RDL)
FontSize Element (RDL)
FontStyle Element (RDL)
FontWeight Element (RDL)
Footer Element (RDL)
Format Element (RDL)
GapDepth Element (RDL)
GroupExpression Element (RDL)
GroupExpressions Element (RDL)
Grouping Element (RDL)
GroupsBeforeRowHeaders Element (RDL)
Header Element (RDL)
Height Element (RDL)
HeightRatio Element (RDL)
Hidden Element (RDL)
HideDuplicates Element (RDL)
Hyperlink Element (RDL)
Image Element (RDL)
ImageData Element (RDL)
Inclination Element (RDL)
InitialState Element (RDL)
InsidePlotArea Element (RDL)
InstanceName Element (RDL)
IntegratedSecurity Element (RDL)
InteractiveHeight Element (RDL)
InteractiveWidth Element (RDL)
Interlaced Element (RDL)
KanatypeSensitivity Element (RDL)
KeepTogether Element (RDL)
Label Element (Chart Elements) (RDL)
Label Element (ParameterValue) (RDL)
Label Element (Report Items) (RDL)
LabelField Element (RDL)
Language Element (Report) (RDL)
Language Element (Style) (RDL)
Layout Element (Legend) (RDL)
LayoutDirection Element (RDL)
Left Element (BorderColor) (RDL)
Left Element (BorderStyle) (RDL)
Left Element (BorderWidth) (RDL)
Left Element (Report Items) (RDL)
LeftMargin Element (RDL)
Legend Element (RDL)
Line Element (RDL)
LineHeight Element (RDL)
LinkToChild Element (RDL)
List Element (RDL)
LogScale Element (RDL)
MajorGridLines Element (RDL)
MajorInterval Element (RDL)
MajorTickMarks Element (RDL)
Margin Element (RDL)
Marker Element (RDL)
Matrix Element (RDL)
MatrixCell Element (RDL)
MatrixCells Element (RDL)
MatrixColumn Element (RDL)
MatrixColumns Element (RDL)
MatrixRow Element (RDL)
MatrixRows Element (RDL)
Max Element (RDL)
MergeTransactions Element (RDL)
MIMEType Element (RDL)
Min Element (RDL)
MinorGridLines Element (RDL)
MinorInterval Element (RDL)
MinorTickMarks Element (RDL)
MultiValue Element (RDL)
Name Element (Custom Property) (RDL)
NoRows Element (RDL)
Nullable Element (RDL)
NumeralLanguage Element (RDL)
NumeralVariant Element (RDL)
Omit Element (RDL)
Operator Element (RDL)
PaddingBottom Element (RDL)
PaddingLeft Element (RDL)
PaddingRight Element (RDL)
PaddingTop Element (RDL)
PageBreakAtEnd Element (RDL)
PageBreakAtStart Element (RDL)
PageFooter Element (RDL)
PageHeader Element (RDL)
PageHeight Element (RDL)
PageWidth Element (RDL)
Palette Element (RDL)
Parameter Element (RDL)
ParameterValue Element (RDL)
ParameterValues Element (RDL)
Parameters Element (RDL)
Parent Element (RDL)
Perspective Element (RDL)
PlotArea Element (RDL)
PlotType Element (RDL)
PointWidth Element (RDL)
Position Element (DataLabel) (RDL)
Position Element (Legend) (RDL)
Position Element (Subtotal) (RDL)
Position Element (Title) (RDL)
PrintOnFirstPage Element (RDL)
PrintOnLastPage Element (RDL)
ProjectionMode Element (RDL)
Prompt Element (ConnectionProperties) (RDL)
Prompt Element (ReportParameter) (RDL)
Query Element (RDL)
QueryParameter Element (RDL)
QueryParameters Element (RDL)
Rectangle Element (RDL)
RepeatOnNewPage Element (RDL)
RepeatWith Element (RDL)
Report Element (RDL)
ReportItems Element (RDL)
ReportName Element (RDL)
ReportParameter Element (RDL)
ReportParameters Element (RDL)
Reverse Element (RDL)
Right Element (BorderColor) (RDL)
Right Element (BorderStyle) (RDL)
Right Element (BorderWidth) (RDL)
RightMargin Element (RDL)
Rotation Element (RDL)
RowGrouping Element (RDL)
RowGroupings Element (RDL)
Scalar Element (RDL)
SeriesGrouping Element (RDL)
SeriesGroupings Element (RDL)
Shading Element (RDL)
ShowGridLines Element (RDL)
Size Element (RDL)
Sizing Element (RDL)
SortBy Element (RDL)
SortExpression Element (RDL)
SortExpressionScope Element (RDL)
SortTarget Element (RDL)
Sorting Element (RDL)
Source Element (RDL)
Static Element (RDL)
StaticCategories Element (RDL)
StaticColumn Element (RDL)
StaticColumns Element (RDL)
StaticMember Element (RDL)
StaticRow Element (RDL)
StaticRows Element (RDL)
StaticSeries Element (RDL)
Style Element (RDL)
Subreport Element (RDL)
Subtotal Element (RDL)
Subtype Element (RDL)
Table Element (RDL)
TableCell Element (RDL)
TableCells Element (RDL)
TableColumn Element (RDL)
TableColumns Element (RDL)
TableGroup Element (RDL)
TableGroups Element (RDL)
TableRow Element (RDL)
TableRows Element (RDL)
TextAlign Element (RDL)
Textbox Element (RDL)
TextDecoration Element (RDL)
ThreeDProperties Element (RDL)
Timeout Element (RDL)
Title Element (RDL)
ToggleImage Element (RDL)
ToggleItem Element (RDL)
ToolTip Element (RDL)
Top Element (BorderColor) (RDL)
Top Element (BorderStyle) (RDL)
Top Element (BorderWidth) (RDL)
Top Element (Report Items) (RDL)
TopMargin Element (RDL)
Transaction Element (RDL)
Type Element (Chart) (RDL)
Type Element (Marker) (RDL)
UnicodeBiDi Element (RDL)
UsedInQuery Element (RDL)
UserSort Element (RDL)
ValidValues Element (RDL)
Value Element (DataLabel) (RDL)
Value Element (DataValue) (RDL)
Value Element (Field) (RDL)
Value Element (Image, BackgroundImage) (RDL)
Value Element (Parameter) (RDL)
Value Element (ParameterValue) (RDL)
Value Element (QueryParameter) (RDL)
Value Element (Textbox) (RDL)
Values Element (Values) (RDL)
ValueAxis Element (RDL)
ValueField Element (RDL)
Values Element (RDL)
VerticalAlign Element (RDL)
Visible Element (RDL)
Visibility Element (RDL)
WallThickness Element (RDL)
Width Element (RDL)
WidthSensitivity Element (RDL)
WritingMode Element (RDL)
Value Element (CustomProperty) (RDL)
ZIndex Element (RDL)
Expand Minimize
This topic has not yet been rated - Rate this topic

Direction Element (RDL)

SQL Server 2005

Indicates whether the items are sorted in ascending or descending order.

XML
Copy 

<SortBy>
     ...
        <Direction>...</Direction>
    ...
</SortBy>

Characteristic Description

Data type and length

String

Default value

None

Cardinality

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

Relationship Element

Parent element

SortBy

Child element

None

The Direction element must contain one of the following values:

  • Ascending
  • Descending
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.