Data Sorting in Reports V2

• Mar 26, 2018

The following data sorting approaches are available in Reports V2.

1. Use XtraReports sorting.
2. Use the CollectionSourceBase.Sorting property of the CollectionDataSource or ViewDataSource (see Data Sources for Reports V2).
3. Use ReportParametersObjectBase.GetSorting method of the Parameters Object (a ReportParametersObjectBase descendant).

Sorting Property of the Data Source

The CollectionSourceBase.Sorting property of the CollectionDataSource and ViewDataSource components specifies a list of sorting rules. You can add rules by clicking the ellipsis button next to the Sorting value in the Properties window.

The data is sorted on the client side.

You can also use the following code to modify Sorting from Report Scripts.

C#

private void xtraReport1_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) {
    var report = (DevExpress.XtraReports.UI.XtraReport)sender;
    var dataSource = (DevExpress.Persistent.Base.ReportsV2.ISupportSorting)report.DataSource;
    dataSource.Sorting.Clear();
    dataSource.Sorting.Add(
        new DevExpress.Xpo.SortProperty("FullName", DevExpress.Xpo.DB.SortingDirection.Ascending));
}

VB.NET

Private Sub xtraReport1_BeforePrint(ByVal sender As Object, ByVal e As System.Drawing.Printing.PrintEventArgs)
    Dim report = CType(sender, DevExpress.XtraReports.UI.XtraReport)
    Dim dataSource = CType(report.DataSource, DevExpress.Persistent.Base.ReportsV2.ISupportSorting)
    dataSource.Sorting.Clear()
    dataSource.Sorting.Add(New DevExpress.Xpo.SortProperty("FullName", DevExpress.Xpo.DB.SortingDirection.Ascending))
End Sub

Parameters Object

Sorting via the Parameters Object is performed in a manner similar to filtering. For details, refer to the Data Filtering in Reports V2 topic.