Open topic with navigation

Sort

If you do not want grouped report results (as described in a Group), but you do expect sorted results, then specify a sort (instead of a grouping).

Note: A report that has a sort order defined can only display up to 100,000 lines.

To specify a sort order:

To edit on the Classic Report, click the Query Editor link. To edit the query in a Smart Report, make sure the is enabled and click the icon.

  1. In Field, select the field on which you want to sort the report.
  2. In Criteria (in the same row), select the sort criteria.
  3. To specify more sorting criteria, provide values in the Then By rows.