Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 follows
    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.