> Task 7: | Create the orders subreport

> The orders subreport lists the orders for each customer in a row and column format. It displays the order number and date of each order. To iterate through the Orders data set rows and display them in a row and column format, you use the table element.

> 1 | Choose Layout to return to the layout editor.

> 2 | Drag a table element from the palette, and drop it below the [CUSTOMERNAME] data element, in the detail area. Insert Table prompts you to specify the number of columns and detail rows to create for the table. The dialog also prompts you to select a data set to bind with the table.

> 3 | On Insert Table, specify the following values, as shown in Figure 13‑14:

> n | In Number of columns, type 2.

> n | In Number of details, type 1.

> n | In Data Set, select Orders from the drop-down list.

> Figure 13‑14 | Properties specified for the table

> Choose OK. A table appears in the detail area of the list, as shown in Figure 13‑15.

> Figure 13‑15 | Table inserted in the detail area of the list

> 4 | Choose Data Explorer, expand Data Sets, then expand Orders. The columns that you specified in the query appear below Orders.

> 5 | Drag ORDERNUMBER from Data Explorer, and drop it in the first cell of the table’s detail row.

> In the layout editor, the table cell in which you dropped the data set field contains a data element that displays [ORDERNUMBER]. Above this data element is a label element that the layout editor automatically adds to the header row. This label displays the field name as static text and serves as the column heading.

> 6 | Drag ORDERDATE from Data Explorer, and drop it in the second cell in the detail row. The report page should look like the one shown in Figure 13‑16.

> Figure 13‑16 | Report design includes the orders subreport

> 7 | Sort the order rows by order number.

> 1 | Select the Orders 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 ORDERNUMBER from the drop-down list.

> o | In Direction, use the default value, Ascending.

> 8 | Preview the report. The report should look like the one shown in Figure 13‑17.

> Figure 13‑17 | Preview of the report shows repeated order records

> The same order records appear for every customer because you specified a default value of 103 for customerNumber when you created the data set parameter, CustID. Because of this default value, the orders subreport always displays the order records for customer 103. The solution is to update the value of the CustID parameter dynamically each time the customer row in the master report changes. This procedure is described in the next task.

(c) Copyright Actuate Corporation 2009