8. The Group by example

The database entry departmentEmployeesGrouping.xre  shows how to use the "group by" feature. The example takes as input a list of employees and groups them by status (in the test file there are 2 status, active and inactive).

For grouping 2 areas are required,


one group header and one group detail:

Group detail areas have the following restrictions:

Note nested groups are not supported.

Group footers

The example departmentEmployeesGrouping_footer.xre shows how to create group footers. Group footers are used to show total fields of the values in the group for each value being grouped. In the example the group footer is used to show the total number of employees for each status.


Group footers have to be implemented as follow: