Task 5:  Lay out the report

In this procedure, you insert elements in the report page to display the data from the data set that you created previously. You start by inserting a table element, then you insert data elements in the table. It is important to understand the functionality that the table provides. The table:

Iterates through all the data rows that a data set returns

Enables you to lay out data easily in a row and column format

1	Choose Palette. The palette displays all the elements that you can place in a report.

2	Drag a table element from the palette, and drop it in the report in the layout editor. 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	In Insert Table, specify the following values:

In Number of columns, type 3.

In Number of details, type 1.

In Data Set, select Customers from the drop-down list.

[inserttable.gif]

Choose OK. A table appears in the layout editor.

4	Choose Data Explorer.

5	In Data Explorer, expand Data Sets, then expand Customers. The columns that you specified in the query appear below Customers.

6	Drag CUSTOMERNAME from Data Explorer, and drop it in the first cell in the table’s detail row, as shown in Figure 1-14. The detail row displays the main data in the report. In the generated report, the detail row repeats to display all the data rows from the data set.

[layout1.png; to create example screenshots within book margins using eclipse relase 4.2, set the report’s left & right margins to 0.25 and 6.5. Using these margins, the screenshots in the book match exactly what the user sees. Setting the margins at this step causes table columns to adjust, as shown in all examples that follow. mjh 060612]

Figure 1-14  Dragging a column from Data Explorer, and dropping it in a table cell

[layout1.png]

In the layout editor, the table cell in which you dropped the CUSTOMERNAME field contains a data element that displays [CUSTOMERNAME]. Above this data element is a label element that the layout editor automatically added to the header row. This label displays the field name as static text. It serves as the column heading. Figure 1-15 shows the data and label elements.

Figure 1-15  Data and label elements in a table

[layout2.png]

7	Drag PHONE from Data Explorer, and drop it in the second cell in the detail row.

8	Drag CONTACTFIRSTNAME, and drop it in the third cell in the detail row.

9	Drag CONTACTLASTNAME, and drop it in the third cell in the detail row, below CONTACTFIRSTNAME. The report page should look like the one shown in Figure 1-16.

Figure 1-16  Customer and contact information added to a table

[layout3.png]

10	Choose Preview, the tab at the bottom of the layout editor. BIRT Report Designer generates and displays the report in HTML format, as shown in Figure 1-17. Scroll down to see the entire report.

As Figure 1-17 shows, the data is correct, but it appears in random order. It makes more sense to sort the data alphabetically by customer name. The report’s appearance also needs improvement.

Figure 1-17  Preview of report data

[output1.png]