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, check number, and amount of each order. 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	Choose Layout to return to the layout editor.

2	Choose Data Explorer, and expand Data Sets.

3	Drag the Payments data set, and drop it below the orders subreport, in the detail area of the list.

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 labels display the field names as static text and serve as the column headings. The report design should look like the one shown in Figure 13‑22.

Figure 13‑22

Report design includes the payments subreport

4	Sort the payment rows by payment date.

1	Select the Payments table.

2	In Property Editor, choose Sorting.

3	On the Sort page, choose Add to create a sort expression.

4	On New Sort Key, specify the following values, then choose OK:

o	In Key, select PAYMENTDATE from the drop-down list.

o	In Direction, use the default value, Ascending.

5	Preview the report. The report should look like the one shown in Figure 13‑23.

Figure 13‑23

Report preview shows repeated payment records

As with the orders subreport when you first created it, 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. Because of this default value, the payments subreport always displays the payment records for customer 103. 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.