The Page Numbering property specifies how page numbers are calculated for fields that have a Source of &Physical Page Number, &Total Number of Physical Pages, &Logical Page Number, or &Total Number of Logical Pages.
Applies to |
Page number fields |
Values |
The settings for each page are based on the logical or physical page as specified by the field's Source. |
Default |
Blank |
Required/Optional |
Optional |
The figure below illustrates the differences between logical page, physical page, and panel numbering. Note that each region may contain multiple logical pages. Furthermore, within each logical page you may have multiple panels. In the figure, physical pages are numbered consecutively starting with the Header Section pages. This assumes that you selected Header Section, Body Section, and Trailer Section in the Page Numbering dialog box.
If the Reset At value is a repeating frame, do not have the field appear on pages where the repeating frame does not appear. Because the value of the field is determined by the repeating frame, the results will be unpredictable on pages where the repeating frame does not appear. To avoid this situation, you can do any one of the following:
Similarly, if the field is not inside the repeating frame it resets at, and multiple instances appear on the same page, Reports Builder cannot determine the value of the field and the results are again unpredictable. To avoid this situation, you can do any one of the following:
Suppose that you want to number the physical pages of the Main Section of your report:
Create a field named F_PAGE and set the Source property to &Physical Page Number.
In the Field Property Inspector for F_PAGE, set the Page Numbering property by filling out the Page Numbering dialog box as follows:
Check Main Section and uncheck Header Section and Trailer Section because you only want to number the Main Section pages.
Type 1 in the Start At setting.
Type 1 in the Increment By setting.
Type &Report under Reset At to number all the pages in the Main Section consecutively.
Position F_PAGE in the Paper Layout view.
Suppose that you want to have the page number at the top of each page of your report. Furthermore, you want the page number to be of the form "Page n of m pages":
Create a field named F_PAGE and set the Source property to &Physical Page Number.
In the Field Property Inspector, set the Page Numbering property by filling out the Page Numbering dialog box as follows:
Check Main Section and uncheck Header Section and Trailer Section because you only want to number the Main Section pages.
Type 1 in the Start At setting.
Type 1 in the Increment By setting.
Type &Report under Reset At because you don't want the page numbers to reset to zero until the report is done.
Create a field called F_TOTPGE and set the Source property to &Total Number of Physical Pages.
Do either of the following:
Hide these fields (that is, set the Visible property to No) and reference
them within boilerplate text:
Page &F_PAGE of &F_TOTPGE
Alternatively, position F_PAGE and F_TOTPGE beside each other. Insert boilerplate to the left of F_PAGE that contains the text "Page". Insert boilerplate between F_PAGE and F_TOTPGE that contains the text "of".
Suppose that you have a repeating frame (R_1) with instances that span several pages and you want to number the physical pages that each instance spans. Assume also that you want the page number to be of the form "Page n of m pages":
Create a field named F_PAGE and set the Source property to &Physical Page Number.
In the Field Property Inspector for F_PAGE, set the Page Numbering property by filling out the Page Numbering dialog box as follows:
Check Main Section and uncheck Header Section and Trailer Section because you only want to number the Main Section pages.
Type 1 in the Start At setting.
Type 1 in the Increment By setting.
Type &R_1 under Reset At because you want the page numbers to reset at each repeating frame instance.
Create a field called F_TOTPGE and set the Source property to &Total Number of Physical Pages.
In the Field Property Inspector for F_TOTPGE, set the Page Numbering property by filling out the Page Numbering dialog box as follows:
Type &R_1 under Reset At because you want the page numbers to reset at each repeating frame instance.
Set the Print Condition of F_PAGE and F_TOTPGE such that they will print on all logical pages of R_1:
Set the Print Condition Type property to All
Set the Print Condition Object property to Enclosing Object
Do either of the following:
Hide these fields (that is, set the Visible property to No) and create
a boilerplate text object inside R_1 with the following text:
Page &F_PAGE of &F_TOTPGE
Alternatively, position F_PAGE and F_TOTPGE beside each other, inside R_1, using the Paper Layout view. Insert boilerplate to the left of F_PAGE that contains the text "Page". Insert boilerplate between F_PAGE and F_TOTPGE that contains the text "of".
Copyright © 1984, 2005, Oracle. All rights reserved.