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

19.4 Redefault the Layout

To redefault the layout to use the additional query data:

  1. In the Object Navigator, click the report name.

  2. Choose Tools > Report Wizard to re-enter the wizard.

  3. In the Report Wizard, on the Groups page, click G_custid1 in the Available Groups list and click Down to specify the Print Direction and move this group to the Displayed Groups list.

  4. On the Fields page, click prodname and amount in the Available Fields list and click the right arrow (>) to move these fields to the Displayed Fields list.

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

    Fields Labels Width

    prodname

    Product Name

    30

    amount

    Amount

    9


  6. On the Template page, click Finish to display your report output in the Paper Design view. It should look something like this:

Figure 19-5 Revised report layout in Paper Design view

Description of Figure 19-5 follows
Description of "Figure 19-5 Revised report layout in Paper Design view"

Note that the data is still grouped by the Sales Representative with customer data listed below each Sales Representative. But now, the individual products sold to the customers are listed below each customer. The report now has multiple pages.