Download itapp User Manual

CHAPTER 6 CONFIGURATION
6.5.4
Grouping Fields
The Group By Fields section of the dialog box lets you specify the
field that the aggregate function applies to.
X To specify the field that the aggregate function applies to
1
Select a field in the Group By section and click Add.
Example: In the above example, you want to report on the
first name and on the number of people in the office or
provider who have that first name.
• Select First Name in the Group By section of the dialog box
and click Add.
The report now counts distinct first names.
2
6.5.5
Go to Section 6.5.5.
Ordering Fields
The Order By Fields section lets you specify the order in which
the records appear in the report. The order can be ascending or
descending. You can specify multiple fields.
X To specify an order for the fields
1
Select a field in the Order By section of the dialog box.
2
Select Ascending or Descending and click Add.
3
Select an additional field if you wish.
Example: Consider the example shown in Figure 10.
Figure 10 Example of Report Ordering
In this example:
• The records will be ordered by First Name in descending
order.
• If two or more records have the same first name, they will
be ordered by the last name in ascending order.
• If two or more records have the same first and last names,
the order is not specified.
itapp-User-Manual-v03_12_00-R01
137