41.7 Create a Layout

Now that you have a working data model, the steps in this section will help you to create a layout.

To create a paper layout:

1. In the Object Navigator, right-click the report name and choose Report Wizard.

2. In the Report Wizard, on the Report Type page, select Create Paper Layout Only.

3. On the Style page, type My Employees in the Title field, select Group Above.

4. On the Groups page, click the following fields in the Available Fields list and click Down to specify the Print Direction and move them to the Group Fields list:

   • G_conlabel

   • G_DEPARTMENT_ID

   • G_EMPLOYEE_ID

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

   • DEPARTMENT_NAME

   • EMPLOYEE_ID

   • START_DATE

   • END_DATE

   • JOB_ID

   • CS_port_count

6. On the Labels page, change the labels and field widths as follows:

   Table 41-3 Field description of Labels page

   Fields	Labels	Width
   DEPARTMENT_NAME	Department	30
   EMPLOYEE_ID	Employee ID	8
   START_DATE	Start Date	9
   END_DATE	End Date	9
   JOB_ID	Job ID	10
   CS_port_count	Total:	12

   
   

7. On the Template page, choose Predefined template and click Beige, then click Finish to display your report output in the Paper Design view. It should look something like this:

   Figure 41-8 Paper Design view for the REF CURSOR report

   
   Description of "Figure 41-8 Paper Design view for the REF CURSOR report"
   
   

   Note:

   You can open the provided file ref_emp66.rdf and display the Paper Design view to compare your results.

8. Save the report as ref_66_your_initials.rdf.