Sorting Data in Active Reports
Copyright © 2019 EarthSoft, Inc • Modified: 12 Nov 2019
The data output from an active report can be sorted using the ORDER BY SQL statement. Examples of Ascending and Descending orders are listed below.
ORDER BY "FIELD_NAME" DESC
ORDER BY "FIELD_NAME" ASC
Combined sorting is possible by combining the two order types:
1.ORDER BY "FIELD_ONE" DESC
2.ORDER BY "FIELD_TWO" ASC
Sorting the data by descending ANALYSIS_DATE. The image below is an example of the report data source modified to sort the data by descending analysis date.