November 2017 - In Report Sorting







Previous Topic  Next Topic 

Did you know...

...that not only do most reports in AWARDS have sorting options available for configuration when running the report, they also have sorting capability on the reports themselves?  This flexibility is especially useful in the event that after a report has been run you decide you want to re-sort using a different data variable, because it saves you from having to go back and run the report again differently.  

For in-report sorting, use the data table's column headers:

  Click the heading of a column to sort the table contents by that variable.

  Click a heading a second time to reverse the sort order.  

  Press <SHIFT> and click additional column headers to sort by more than one data variable.

When sorting is used, an up or down arrow next to a column heading indicates that the table data is being sorted using the column.  The direction of the arrow indicates whether the sorting is in ascending (up arrow) or descending (down arrow) order.

  NOTE: A report's Excel file link is not updated if you change sorting on the report itself; that link only reflects the sorting of the originally generated report.

Bonus tip!  

Using in-report sorting can be an easy way to check for missing data.  Just run a report that includes all of the fields you care about, and then re-sort the report on one column after another.  Each time you sort on a particular column the blank missing data will jump to the top of that column.

  https://demodb.footholdtechnology.com/help/?12151