How to Add sorting to Table item and Crosstab item

To define a sorting for the Table or Crosstab items use the following steps:

Adding sorting to Table/Crosstab data item using Report Designer

1. In theReport Designer

2. Click the Sorting ellipsis.

3. For each sort expression, follow these steps:

   1. Click New.

   2. Type or select an expression by which to sort the data.

   3. From the Direction column drop-down list, choose the sort direction for each expression. ASC sorts the expression in ascending order. DESC sorts the expression in descending order.

4. Click OK.

Adding sorting to Table/Crosstab Group (Row/Column Group) using Report Designer

1. Open theGroup Explorer

2. In theReport Designer, select the Table/Crosstab. This makes the selected item active in theGroup Explorer

3. Choose a Row/Column Group and click its Sorting ellipsis.

4. For each sort expression, follow these steps:

   1. Click New.

   2. Type or select an expression by which to sort the data.

   3. From the Direction column drop-down list, choose the sort direction for each expression. ASC sorts the expression in ascending order. DESC sorts the expression in descending order.

5. Click OK.

Adding sorting to Table/Crosstab data item programatically

Telerik.Reporting.Sorting sorting1 = new Telerik.Reporting.Sorting();
sorting1.Expression = "=Fields.ProductID";
sorting1.Direction = Telerik.Reporting.SortDirection.Asc;

table1.Sortings.Add(sorting1);

Dim sorting1 As New Telerik.Reporting.Sorting()
sorting1.Expression = "=Fields.ProductID"
sorting1.Direction = Telerik.Reporting.SortDirection.Asc

table1.Sortings.Add(sorting1)

See Also

• Table

• Sorting

• SortingCollection

• How to Add groups to Table item and Crosstab item