Specifications

Users Guide 297
CHAPTER 9
Filtering, Sorting, and Grouping
Rows
About this chapter
This chapter describes how you can customize your report by doing the
following in the Report painter:
• Defining filters to limit which of the retrieved rows are displayed in
the report
• Sorting rows after they have been retrieved from the database
• Displaying the rows in groups and calculating statistics on each group
Contents
Filtering rows
You can use WHERE and HAVING clauses and retrieval arguments in the
SQL
SELECT statement for the report to limit the data that is retrieved
from the database. This reduces retrieval time and space requirements at
runtime.
However, you may want to further limit the data that displays in the report.
For example, you might want to:
• Retrieve many rows and initially display only a subset
• Limit the data that is displayed using InfoMaker expression functions
(such as
If) that are not valid in the SELECT statement
Topic Page
Filtering rows 297
Sorting rows 299
Grouping rows 302