Specifications

CHAPTER 5 Defining Reports
Users Guide 177
5 Under Value, specify the right-hand side of the expression. You can:
• Type a value.
• Paste a column, function, or retrieval argument (if there is one) by
selecting Columns, Functions, or Arguments from the pop-up menu.
• Paste a value from the database by selecting Value from the pop-up
menu, then selecting a value from the list of values retrieved from the
database. (It may take some time to display values if the column has
many values in the database.)
• Define a nested
SELECT statement by selecting Select from the pop-
up menu. In the Nested Select dialog box, you can define a nested
SELECT statement. Click Return when you have finished.
6 Continue to define additional
WHERE expressions as needed.
For each additional expression, select a logical operator (
AND or OR) to
connect the multiple boolean expressions into one expression that
InfoMaker evaluates as true or false to limit the rows that are retrieved.
7 Define sorting (Sort view), grouping (Group view), and limiting (Having
view) criteria as appropriate.
8 Click the Return button to return to the Report painter.
Defining ORDER BY
criteria
You can sort the rows that are retrieved into the report by specifying columns
that correspond to the
ORDER BY clause in the SELECT statement.
For example, if you are retrieving information about employees, you can sort
on department, and then within each department, you can sort on employee ID.
❖ To define ORDER BY criteria:
1 Click the Sort tab to make the Sort view available (or select View>Sort if
the Sort view is not currently displayed).
The columns you selected display in the order of selection. You might
need to scroll to see your selections.
2 Drag the first column you want to sort on to the right side of the Sort view.
This specifies the column for the first level of sorting. By default, the
column is sorted in ascending order. To specify descending order, clear the
Ascending check box.