In the “Field list” you may see the same field listed multiple times.  Each of these has a different icon to identify the data type the data will be returned in.  These are as follows:

 

Icon	Type	Details
	Number	Data will be returned in a number format.  Any sort applied will be a numeric sort (e.g. 1, 2, 3).  Date fields that have this type will be sorted based on the first two digits only.
	Text	All data displayed is in text format.  Any sort applied will be a text sort.
	Boolean	Data is either a yes or no (e.g. a check box).
	Date/Time	A date/time format which will sort data using a calendar sort based on year, month and day.

To apply a date sort on a collection:

1. In the Report Designer, click on the detail band that you would like to sort.

2. Click the [>] button (outlined in red above).

3. Click the [...] icon beside the Sort Fields field of the "Detail Tasks" to open the Collection editor.
4. Click the [ADD] button to add a member to this list.  In this screen, please ensure the field select is of a Date/Time type.

5. Under the "Properties" section, specify the field that you wish to be sorted on (e.g. in this example, this report is sorted by Number) and also the sort order.
6. Click [OK] and save your report.
7. The collection of data should now be sorted by the selected column.