Sorting
Sorting data in the Results and Table section is a very common and flexible operation allowing quick add, modify, and remove Sort conditions to the section without needing to rerun the query to refresh the dataset. The Sort line of the section is very similar to the Sort line of the Query section. Items are added to the Sort line of the Results and Table section using one of three methods:
|
Right-click method |
Drag-and-drop method |
Double-click method |
|---|---|---|
|
Highlight the column of data or column name |
Highlight the column of data or column name |
Double-click the column header name |
|
Right-click and select either the Sort Ascending or Sort Descending menu item. |
Drag-and-drop the column of data into the Sort line. |
Each of the methods clear out the existing sort option except the drag-and-drop method, which adds the column to the Sort line without clearing the other sorts created. The column order in the Sort line identifies the sort order of the columns driving the sorting of the dataset...
