How to create a GROUP BY clause manually

1	In the graphical information object editor, choose Group By.

2	In Group By, deselect Use Automatic Grouping.

3	In Available, expand the Computed and Output nodes to view the available columns.

By default, Information Object Designer displays only output columns and non-aggregate computed fields. To group on a column that is not an output column, choose Show all.

4	In Available, select the appropriate column, and choose Select. This action moves the column name to Selected, as shown in Figure 3-41.

Figure 3-41

Selecting a GROUP BY column

5	Repeat the previous step for each GROUP BY column.

6	To change the order of the GROUP BY columns, select a column in Selected, and use the up or down arrow.

Copyright Actuate Corporation 2012