Sort Data (Runtime Sample)

• Mar 20, 2023

This code sample demonstrates how to sort report data at runtime. In this example, the report’s DetailBand is bound to the Products table of the sample Northwind database. The products are sorted by their names in ascending order:

To sort report data in code, create the GroupField object and add it to the DetailBand.SortFields collection:

C#

using DevExpress.XtraReports.UI;
// ...
    TestReport rep = new TestReport();
    DetailBand detail = rep.Bands[BandKind.Detail] as DetailBand;
    detail.SortFields.Add(new GroupField("ProductName"));

VB.NET

Imports DevExpress.XtraReports.UI
' ...
    Dim rep As New TestReport()
    Dim detail As DetailBand = TryCast(rep.Bands(BandKind.Detail), DetailBand)
    detail.SortFields.Add(New GroupField("ProductName"))

You can use the calculated field to implement custom logic to sort the report data. For more information, review the following help topic: Sort Data by Custom Criteria.