Specifications

www.evisions.com Argos - Argos Report Writers Guide Page 27 of 118
Document Version 1.0 – Last Updated 10.18.2010
Sort
Click on the Sort tab and the following will appear.
Figure 35 – The Sort Tab within the Edit Report dialog box
You need to activate sorting by clicking the “Override the main report query sort” box
Move items over that you wish to sort on by double-clicking on the item or single-click
then clicking the arrow pointing to the right.
You can reorganize fields by clicking the up or down arrow. You can change the sort order
to ascending and descending by clicking on the double arrows.
Filters and sorts involve editing the report so once they are turned on, only a Report Writer
can deactivate or change them, and Report Viewers cannot. To deactivate a filter or sort
just uncheck the activate box. You do not need to clear out the filters and sorts. The Filters
tab adds filters to the Report query, so all the conditions and filters in the DataBlock run,
and then your additional filters are applied.
Note: If you define a sort order by using the sort tab, you will override the sort order
in the DataBlock, so you essentially will be ordering the recordsets twice. The
DataBlock will sort based on whatever sort order it is using. When the report is
created it will reorder the recordsets based on the report sort order.
After choosing your sort options, click OK then execute the report to see the results of
your specified sort.
Sorting Options
Double-click Ascending/Descending to toggle
sort by ascending or descending order.
As shown in the figure at the left, you can sort
using multiple fields. The figure illustrates
sorting by department name (ascending), then
by salary within the department (descending).