Specifications

CHAPTER 5 Defining Reports
Users Guide 159
As you select columns, they display in the grid at the bottom of the dialog box
in the order in which you select them. If you want the columns to display in a
different order in the report, select a column name you want to move in the grid
and drag it to the new location.
Specifying sorting criteria
In the grid at the bottom of the Quick Select dialog box, you can specify if you
want the retrieved rows to be sorted. As you specify sorting criteria, InfoMaker
builds an
ORDER BY clause for the SELECT statement.
❖ To sort retrieved rows on a column:
1 Click in the Sort row for the column you want to sort on.
InfoMaker displays a drop-down list:
2 Select the sorting order for the rows: Ascending or Descending.
Multilevel sorts
You can specify as many columns for sorting as you want. InfoMaker processes
the sorting criteria left to right in the grid: the first column with Ascending or
Descending specified becomes the highest level sorting column, the next
column with Ascending or Descending specified becomes the next level
sorting column, and so on.
If you want to do a multilevel sort that does not match the column order in the
grid, drag the columns to the correct order and then specify the columns for
sorting.
Specifying selection criteria
You can enter selection criteria in the grid to specify which rows to retrieve.
For example, instead of retrieving data about all employees, you might want to
limit the data to employees in Sales and Marketing, or to employees in Sales
who make more than $80,000.
As you specify selection criteria, InfoMaker builds a
WHERE clause for the
SELECT statement.