Sort Data
To sort the data displayed in the report band by column, specify the data field for that column as the band’s sorting field.
In this example, the report’s DetailBand is bound to the Products table of the sample Northwind database. To sort the products by their names in ascending order, do the following:
In the Detail band’s smart tag, click the ellipsis next to the Sort Fields editor:
In the invoked Group Field Collection Editor, specify the
[ProductName]field as the field by which to sort the data:
Click OK to apply changes and close the dialog.
Switch to the Preview tab. Products are sorted by their names in ascending order:
