Specifications

CHAPTER 5 Defining Reports
Users Guide 175
For the case of the array defined as
deptarray, the expression in the Where view
will look like the following expression. You can paste the :
deptarray argument
using the pop-up menus in the value area of the Where view:
Supplying values for
an array argument
When you preview the report, you are prompted to supply the department
values. InfoMaker retrieves rows that match one of the set of values that you
supply. For example, if you supply the department IDs 100, 200, and 500 as
shown, your report displays information about these departments:
Specifying selection, sorting, and grouping criteria
In the SELECT statement associated with a report, you can add selection,
sorting, and grouping criteria that are added to the SQL statement and
processed by the DBMS as part of the retrieval.
Table 5-5: Adding selection, sorting, and grouping criteria to the
SELECT statement
To do this Use this clause
Limit the data that is retrieved from the database
WHERE
Sort the retrieved data before it is brought into the report ORDER BY
Group the retrieved data before it is brought into the
report
GROUP BY
Limit the groups specified in the GROUP BY clause HAVING