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.
2 Drag a list element from the palette, and drop it in the report. The list element appears in the report, as shown in Figure 13‑8.
Figure 13-8 BIRT creates a column binding for each column in the Customers data set. Figure 13‑9 shows the binding information for the list.
Figure 13-9
4 Choose Data Explorer, expand Data Sets, then expand Customers. The columns that you specified in the query appear below Customers.
5 Drag CUSTOMERNAME from Data Explorer, and drop it in the detail area of the list. Figure 13‑10 shows what the report design looks like so far.
Figure 13-10
6 Choose Preview to preview the report. The report should look like the one shown in Figure 13‑11. The report lists all the customer names in the order in which the query returns them.
Figure 13-11
2 In the layout editor, select the list element. Hover the mouse pointer over the bottom left corner until you see the List tab, then choose the tab.
Figure 13-12 Choose OK. The Sort page displays the sort expression that you defined for the list.
Figure 13-13
(c) Copyright Actuate Corporation 2008 |