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

17.3 Add Summary Columns for the Header Data

For the header that you want to create (that is, departments found on this page), you need to create two summary columns that compute the values you need in order to populate the header.

  1. In the Report Editor, click the Data Model button in the toolbar to display the Data Model view.

  2. Click the Summary Column tool in the tool palette, then click in an open area of the Data Model view to create a summary column.

  3. Double-click the new summary column object (CS_1) to display the Property Inspector, and set the following properties:

    • Under General Information, set the Name property to FirstDeptRec.

    • Under Summary, set the Function property to First, set the Source property to DEPARTMENT_ID, set the Reset At property to Page.

  4. Create a second summary column, and set its properties as follows:

    • Under General Information, set the Name property to LastDeptRec.

    • Under Summary, set the Function property to Last, set the Source property to DEPARTMENT_ID, set the Reset At property to Page.

    Your data model should now look like this:

Figure 17-3 Data Model with Summary Columns for Header

Description of Figure 17-3 follows
Description of "Figure 17-3 Data Model with Summary Columns for Header"