13.4 Use the Paper Layout View to Create Two Layouts

Once your data model is complete, you need to create a layout for the data objects to display in the report output. This particular report consists of two separate layouts:

a group left layout for listing customer purchases individually

a tabular layout that shows a summary of the customer's purchases by product

Given that two layouts are required, you need to create the first layout through the Report Wizard and the second by inserting a report block. The reason for taking this approach is that the Report Wizard overwrites everything in the layout. Hence, you can only create the first layout through the Report Wizard. Additional layouts must be created by inserting a report block.

To create the first layout:

Choose Tools > Report Wizard.

On the Report Type page, select Create Paper Layout only.

On the Style page, select Group Left.

On the Groups page, ensure that all of the groups from your data model appear in the Displayed Groups list.

On the Fields page, click column names and the right arrow (>) or left arrow (<) to move columns so that the following columns appear in the Displayed Fields list:

In the Report Block Wizard, on the Style page, select Tabular, then click Next.

On the Groups page, click G_CUSTID1 and click Down to specify the Print Direction and move this group to the Displayed Groups list, then click Next. (G_CUSTID1 should be the only group in the Displayed Groups list when you are done.)

On the Fields page, click the following fields and click the right arrow (>) to move them to the Displayed Fields list, then click Next:

DESCRIP

SumITEMTOTPerCUSTID1.

DESCRIP and SumITEMTOTPerCUSTID1 should be the only fields in the Displayed Fields list when you are done.

On the Labels page, change the labels as follows, then click Next:

Table 13-2 Field Description

Fields

Labels

DESCRIP

Product

SumITEMTOTPerCUSTID1

Sum Total

On the Template page, make sure Beige is selected under Predefined Template, then click Finish to display your report output in the Paper Design view. It should look like this: