Previous Next

Task 6:  Create the customer master report

You use a list element to create the master report and organize the orders and payments subreports within it. The list iterates through the customer data rows and creates the related orders and payments subreports for each record. For the sake of simplicity, the customer report displays just the customer name. It can, of course, display additional data, such as customer address, phone number, and credit limit.

1  

Figure 13-7 List element

Figure 13-7  List element
2  
1  
2  
BIRT creates a column binding for each column in the Customers data set. Figure 13-8 shows the binding information for the list.

Figure 13-8 Binding information for the list element

Figure 13-8  Binding information for the list element
3  
Choose Data Explorer, expand Data Sets, then expand Customers. The columns that you specified in the query appear below Customers.
4  
Drag CUSTOMERNAME from Data Explorer, and drop it in the detail area of the list. Figure 13-9 shows what the report design looks like so far.

Figure 13-9 Data set field in the list element

Figure 13-9  Data set field in the list element
5  
Preview the report. The report should look like the one shown in Figure 13-10. The report lists all the customer names in the order in which the data set returns them.

Figure 13-10 Data preview for the master report

Figure 13-10  Data preview for the master report
6  
1  
2  
In the layout editor, select the list element. Hover the mouse pointer over the bottom left corner to locate the List tab, then choose the tab.
3  
4  
5  
*
*

Figure 13-11 Sort definition

Figure 13-11  Sort definition
7  

(c) Copyright Actuate Corporation 2012