Task 8: Format the report Now that the report displays the correct data, you can focus on improving the report’s appearance. You perform the following tasks in this section: n Remove credit limit data from the detail rows. n Display group headings on the first row of each group. n Separate each group with a line. n Display the number of customers text on one line. Remove credit limit data from the detail rows To verify that data appears in the correct credit limit groups, it is useful to display each customer’s credit limit. Now that we have verified the data, we can delete the individual credit limit information from the report. 1 Choose Layout to return to the layout editor. 2 Delete the [CREDITLIMIT] data element from the detail row. 3 Preview the report. It should look like the one shown in Figure 8‑23. Figure 8‑23 Report preview without credit limit data for each row Display group headings on the first row of each group The credit limit group headings appear in their own rows, above the detail rows of each group. In this procedure, you drop the group headings so that they appear in the first detail row of each group. 1 Choose Layout to return to the layout editor. 2 Select the cell that contains the group heading, as shown in Figure 8‑24. Be sure to select the cell and not the data element in the cell. Figure 8‑24 Group heading cell selected 3 In the general properties of Property Editor, set Drop to Detail. In the report design, the group heading still appears above the detail row because technically the element is still in the group header row. 4 Preview the report. The group headings appear in the first row of each group, as shown in Figure 8‑25. Figure 8‑25 Report preview showing dropped group headings Separate each group with a line Drawing a line to separate each group makes it easier to see the groups of data. 1 Choose Layout to return to the layout editor. 2 Select all the cells in the group footer row. To select multiple cells, press the Shift key as you click each cell. 3 In Property Editor, under Properties, choose Border, then set the border properties, as follows: n Set Style to a solid line. n Set Width to Thin. n Choose the button that shows the bottom border. 4 Add more space between the line and text above it. While the cells are still selected, choose the Padding properties in Property Editor, and set Bottom to 6.0 points, as shown in Figure 8‑26. Figure 8‑26 Property Editor showing padding values for selected cells 5 Preview the report. A line appears at the end of each group, as shown in Figure 8‑27. Figure 8‑27 Report preview showing a line between groups Display the number of customers text on one line The text at the top of the table is centered within the first column. In this procedure, you format the text so that it appears left-aligned and on one line. 1 Choose Layout to return to the layout editor. 2 Using Shift-click, select the first and second cells in the top table header row, as shown in Figure 8‑28. Figure 8‑28 Two cells in the top table header row selected 3 Right-click the selected cells, and choose Merge Cells. 4 Select the [CUSTOMER_TOTAL] element in the merged cell, and in the General properties of the Property Editor, choose the B button and the Left button. 5 Preview the report. It should look like the one shown in Figure 8‑29. Figure 8‑29 Report preview showing Number of customers: 122 on one line
Now that the report displays the correct data, you can focus on improving the report’s appearance. You perform the following tasks in this section:
To verify that data appears in the correct credit limit groups, it is useful to display each customer’s credit limit. Now that we have verified the data, we can delete the individual credit limit information from the report.
The credit limit group headings appear in their own rows, above the detail rows of each group. In this procedure, you drop the group headings so that they appear in the first detail row of each group.
Drawing a line to separate each group makes it easier to see the groups of data.
The text at the top of the table is centered within the first column. In this procedure, you format the text so that it appears left-aligned and on one line.