Specifications

CHAPTER 9 Filtering, Sorting, and Grouping Rows
Users Guide 299
4 Click OK.
Only rows meeting the filter criteria are displayed in the Preview view.
Filtered rows and updates
Modifications of filtered rows are applied to the database when you issue
an update request.
Removing a filter
❖ To remove a filter:
1 Select Rows>Filter from the menu bar.
2 Delete the filter expression from the Specify Filter dialog box, then click
OK.
Examples of filters
Assume that a report retrieves employee rows and three of the columns are
Salary, Status, and Emp_Lname. Table 9-1 shows some examples of filters you
might use.
Table 9-1: Sample filters
Sorting rows
You can use an ORDER BY clause in the SQL SELECT statement for the report
to sort the data that is retrieved from the database. If you do this, the DBMS
itself does the sorting and the rows are brought into InfoMaker already sorted.
However, you might want to sort the rows after they are retrieved. For example,
you might want to:
• Offload the processing from the DBMS
• Sort on an expression, which might not be allowed in the
SELECT
statement but is allowed in InfoMaker
To display these rows Use this filter
Employees with salaries over $50,000
Salary > 50000
Active employees Status = 'A'
Active employees with salaries over
$50,000
Salary > 50000 AND Status = 'A'
Employees whose last names begin
with H
left(Emp_Lname, 1) = 'H'