Sorting Data in Active Reports

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Reports > Active Reports >

Sorting Data in Active Reports

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.

 

Descending order

 

ORDER BY "FIELD_NAME" DESC

 

Ascending order

 

ORDER BY "FIELD_NAME" ASC

 

Combinations

 

Combined sorting is possible by combining the two order types:

 

1.ORDER BY "FIELD_ONE" DESC

2.ORDER BY "FIELD_TWO" ASC

 

Example

 

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.

 

clip0125