PivotGridFieldBase.SortOrder Property

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v21.2.Core.dll

Declaration

[DefaultValue(PivotSortOrder.Ascending)]
public PivotSortOrder SortOrder { get; set; }

<DefaultValue(PivotSortOrder.Ascending)>
Public Property SortOrder As PivotSortOrder

Property Value

Remarks

Data within the PivotGridControl is always sorted against the fields displayed within Column Header Area and Row Header Area (by default, in ascending order). Use the SortOrder property of these fields to change the current sort order. For other fields, changing the SortOrder property value has no effect on data representation until these fields are placed within the Column Header Area or Row Header Area.

You can also use the PivotGridFieldBase.ChangeSortOrder (synchronous) and PivotGridControl.ChangeFieldSortOrderAsync (asynchronous) methods to toggle a field sort order.

To respond to a field’s sort order being changed, handle the PivotGridControl.GridLayout event.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the SortOrder property.

if(!sortOrder.HasValue || sortOrder.Value == PivotSortOrder.Descending)
    otherFields[i].SortOrder = PivotSortOrder.Ascending;
else

    return;
if(rowField.SortOrder == PivotSortOrder.Ascending)
    return;

If Not sortOrder.HasValue OrElse sortOrder.Value = PivotSortOrder.Descending Then
    otherFields(i).SortOrder = PivotSortOrder.Ascending
Else

End If
If rowField.SortOrder = PivotSortOrder.Ascending Then
    Return