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.7 Reference Fields

To reference the page number fields:

  1. In the Paper Layout view, click the Line Color tool in the tool palette.

  2. In the color palette, click No Line.

  3. Click the Text tool in the tool palette.

  4. Position the cursor in the top margin where you would like the page number to appear, and click to create a boilerplate object.

  5. In the new boilerplate object, type Page &F_PAGENO of &F_TOTAL_PAGENO.

    Figure 19-7 Page number source and reference fields in top margin of report

    Description of Figure 19-7 follows
    Description of "Figure 19-7 Page number source and reference fields in top margin of report"

    In the report output, the current page number will appear where you reference the field F_PAGENO, while the total number of pages for each master will appear where you reference the field F_TOTAL_PAGENO. If you wish, you can resize the page number boilerplate text object to lengthen it to ensure that no values for F_TOTAL_PAGENO get truncated.

  6. Save and run your report. Your final report output should look something like this:

    Figure 19-8 Final pages renumbered by repeating frame report output

    Description of Figure 19-8 follows
    Description of "Figure 19-8 Final pages renumbered by repeating frame report output"