Previous Next

Task 5:  Group customer data by credit limit

The report is currently sorted alphabetically by customer name. Recall that in the first tutorial, you specified that the rows in the table be sorted by customer name. In this procedure, you group the data by credit limit in intervals of 50,000. When grouping data, BIRT sorts the rows into groups first, then it sorts the rows within each group, assuming that there is a sort condition specified at the table level. Completing this task sorts the data rows within each credit limit group by customer name.

1  
2  
3  
1  
credit_group
2  
3  
4  
5  
Use the default values for the other options. Choose OK. The table in the report design displays a group header and a group footer row, as shown in Figure 7-6. The table also shows the data element that the layout editor automatically added to the group header row. This data element serves as the group heading and, in the generated report, displays the first credit limit value of each group.

Figure 7-6 Group header and group footer rows in a report design

Figure 7-6  Group header and group footer rows in a report design
4  
5  
6  

Figure 7-7 Report preview showing one of the four credit limit groups

Figure 7-7  Report preview showing one of the four credit limit groups

(c) Copyright Actuate Corporation 2013