Help Home

Sorting the Data


You can sort data in column through the Column Header Context Menu.

To sort on a column:

  1. Move your cursor to the header of the column you want to sort. The Column Header Context Menu pops up.
  2. Select Sort from the menu. The column is now sorted.

The Sort function operates in a toggle mode. Therefore, if the column is already sorted, the sort order will be reverse. If the column has never been sorted, it will be first sorted in the ascending order. To reverse the sort order, simply select Sort from the Column Header Context Menu again.

Note

Sorting a column in a report sorts the report by the data values in the sorting column; any previous sort results are not preserved.

Note

To list break group headers in sorted order, before a column is made a break group, sort on the column. However, if you then sort on another data column, the sort order in the break group headers may not be preserved. For example, you first sort on "Product" and then make it a break group. Your report now is grouped by "Product" with product names as break group headers in alphabetical order. If you then sort on the "Sales" column, the order of the break group headers (product names) will depend on the data values in "Sales."


Related Topics: