Grouping: How it works

Assume that we are creating a Sales listing report and we wish to list all the Sales for each salesman in Closed Date order. Assume that our Sales table looks like the one below.

Salesman Closed Date

LLA 12/10/96

DAC 12/15/96

LLA 12/15/96

LLA 12/17/96

Sample Sales Table (unsorted)

First, we specify that the sort order for the report is Salesman first and Closed Date second. Next, we specify that the grouping is on Salesman.

When the report is printed the following events will occur:

•	The table is sorted based on the information specified in the Sort Order dialog.

Salesman Closed Date

DAC 12/10/96

DAC 12/15/96

LLA 12/10/96

LLA 12/15/96

LLA 12/17/96

Sample Sales Table (after sorting)

•	A grouping will start and remain in effect until Salesman is no longer equal to "DAC".

•	The Group Header band will print.

•	The Body band will print for each row where Salesman equals "DAC". This results in Dates "12/10/96" and "12/15/96" being printed.

•	When the Salesman no longer equals "DAC" the Group Footer band is printed.

•	Another group will start and remain in effect until Salesman is no longer equal to "LLA".

•	The Group Header band will print.

•	The Body band will print for each record where Salesman equals "LLA". This results in Dates "12/10/96", "12/15/96" and "12/17/96" being printed.

•	When the Salesman no longer equals "LLA" the Group Footer band is printed.

•	Since there are no more rows in the data source, the report terminates.

Also See:

Grouping