Query Builder Sorting

Use the Query Builder Sorting tab to specify which field(s) to sort the data by and whether the data appears in ascending or descending order. The sorting criteria are applied in the order in which they appear on the tab.

Note: 

  • The Query Builder supports many features. The tabs you see depend on the feature you are using.

  • Some reports include predefined sorting criteria that can be deleted if necessary.
  • Blob fields cannot be used to sort data.

    (Binary Large OBject) A data type that contains a large, variable amount of data. Blobs can have binary or text data. Use the Blob Viewer in the SQL Result Set dialog box to see text blob data.

  • Numeric calculated fields cannot be used to sort data because the mathematical calculation is not completed until after the sort is applied.