Previous Next

Task 9:  Create the payments subreport

The payments subreport shows, in a row and column format, the payments that each customer made. It displays the payment date and amount paid. To iterate through the Payments data set rows and display them in a row and column format, you use a table element. This time, you use an alternate and quicker method to insert the table and the data set fields in the table.

1  
2  
3  
BIRT Report Designer inserts a table in the report, and places all the data set fields in the detail row of the table. BIRT Report Designer also inserts labels in the header row of the table. The report design should look like the one shown in Figure 13-20.

Figure 13-22 Report design includes the payments subreport

Figure 13-20  Report design including the payments subreport
4  
1  
2  
3  
4  
o  
o  
5  

Figure 13-23 Report preview shows repeated payments records

Figure 13-21  Report preview showing repeated payment records
The same payment records repeat for every customer because you specified a default value of 103 for customerNumber when you created the parameter, CustID, for the Payments data set. Just as you did for the orders subreport, you need to dynamically update the value of the CustID parameter for each customer in the master report.

(c) Copyright Actuate Corporation 2011