ASPxGroupSummarySortInfo Class
Contains the information required to sort group rows by summary values.
Namespace: DevExpress.Web
Assembly: DevExpress.Web.v20.2.dll
NuGet Package: DevExpress.Web
Declaration
Remarks
To sort group rows by summary values, you should create a new ASPxGroupSummarySortInfo object with the specified settings, and add it to the ASPxGridView.GroupSummarySortInfo collection.
Each ASPxGroupSummarySortInfo object contains settings used to calculate summary values for groups of rows. The ASPxGroupSummarySortInfo.GroupColumn property defines the nesting level of the group whose rows are sorted. The summary item and the sort order are specified by the ASPxGroupSummarySortInfo.SummaryItem and ASPxGroupSummarySortInfo.SortOrder properties, respectively.
Example
This example sorts group rows by summary values, so that countries that have the highest sales appear at the top of the view.
The image below shows the result:
using DevExpress.Data;
using DevExpress.Web.ASPxGridView;
protected void Page_Load(object sender, EventArgs e) {
grid.GroupSummarySortInfo.Clear();
ASPxGroupSummarySortInfo sortInfo = new ASPxGroupSummarySortInfo();
sortInfo.SortOrder = ColumnSortOrder.Descending;
sortInfo.SummaryItem = grid.GroupSummary["Sales", SummaryItemType.Sum];
sortInfo.GroupColumn = "Country";
grid.GroupSummarySortInfo.AddRange(sortInfo);
}
<dxwgv:ASPxGridView ID="grid" ClientInstanceName="grid" runat="server" DataSourceID="AccessDataSource1" KeyFieldName="OrderID" Width="100%">
<Columns>
<dxwgv:GridViewDataColumn FieldName="CompanyName" VisibleIndex="2" />
<dxwgv:GridViewDataColumn FieldName="City" VisibleIndex="3" />
<dxwgv:GridViewDataColumn FieldName="Region" VisibleIndex="4" />
<dxwgv:GridViewDataColumn FieldName="Country" GroupIndex="0" VisibleIndex="5" />
<dxwgv:GridViewDataColumn FieldName="Sales" VisibleIndex="6" />
</Columns>
<GroupSummary>
<dxwgv:ASPxSummaryItem FieldName="Sales" SummaryType="Sum" DisplayFormat="{0:c}"/>
</GroupSummary>
</dxwgv:ASPxGridView>