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.4 Refine the Data Model

In this section, you will rename some of the objects in the data model so that they have more meaningful names. You will also create a break group.

To refine the data model:

  1. In the Data Model view, drag the title bar of the group G_EMPLOYEE_ID down about 4 inches (10 centimeters) to move the entire group.

  2. Click and drag the column named JOB_ID out of and above G_EMPLOYEE_ID to create a new break group, as shown in the following figure:

    Figure 41-4 Query with group

    Description of Figure 41-4 follows
    Description of "Figure 41-4 Query with group"

  3. Double-click the title bar of the new group that contains JOB_ID to display the Property Inspector, and set the following properties:

    • Under the General Information node, set the Name property to G_conlabel.

  4. In the Data Model view, your data model should look similar to the following:

    Figure 41-5 Data model with group

    Description of Figure 41-5 follows
    Description of "Figure 41-5 Data model with group"

    Note:

    You can open the provided file ref_emp63.rdf and display the Data Model to compare your results.

  5. Save the report as ref_63_yourinitials.rdf.