CrossTabGroupFieldBase.SortBySummaryInfo Property

Allows you to sort field values based on summary values in rows/columns.

Namespace: DevExpress.XtraReports.UI.CrossTab

Assembly: DevExpress.XtraReports.v20.2.dll

NuGet Packages: DevExpress.Reporting.Core, DevExpress.WindowsDesktop.Reporting.Core

Declaration

C#

[SRCategory(ReportStringId.CatData)]
public CrossTabFieldSortBySummaryInfo SortBySummaryInfo { get; }

VB.NET

<SRCategory(ReportStringId.CatData)>
Public ReadOnly Property SortBySummaryInfo As CrossTabFieldSortBySummaryInfo

Property Value

Type	Description
CrossTabFieldSortBySummaryInfo	Settings that allows you to sort field values based on summary values.

Remarks

The Cross Tab displays row and column field values in ascending order.

You can use the SortBySummaryInfo property to sort row/column field values by grand totals values calculated against the specified field.

1. Select a cell you want to sort and expand the SortBySummaryInfo property in the Properties window.
2. Set the CrossTabFieldSortBySummaryInfo.FieldName property to the name of an assigned data source’s field. You can also define a field that is not currently displayed in the Cross Tab.
3. Use the CrossTabFieldSortBySummaryInfo.SummaryType property to specify which summary function to calculate. The summary type can differ from the summary type currently used in the Cross Tab.
4. Use the SortOrder property to define the sort order.