Progress® Telerik® Reporting R2 2017

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 the Report Designer, right click on a Table/Crosstab and then select Properties.
  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 the Group Explorer window.
  2. In the Report Designer, select the Table/Crosstab. This makes the selected item active in the Group Explorer window.
  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);

See Also