Source property
The Source property specifies where the field gets its values (usually
a column or a parameter).
If Source is a page number value (for example, &Logical
Page Number), you can set the Page
Numbering property to control how the page numbering is done.
Applies to |
Fields |
Values |
Any valid column or parameter name.
&Current Date |
Is the operating system date when the report
runs, after the Runtime Parameter Form is finished. |
&Logical Page Number |
Is the current page number based upon numbering
the output by logical pages. |
&Panel Number |
Is the current panel number within the logical
page. |
&Physical Page Number |
Is the current page number based upon numbering
the output by physical pages. |
&Total Logical Pages |
Is the total number of pages based upon numbering
the output by logical pages. |
&Total Panels |
Is the total number of panels within a logical
page. |
&Total Physical Pages |
Is the total number of pages based upon numbering
the output by physical pages. |
|
Required/Optional |
Required |
Restrictions
- If a field is enclosed in a repeating frame, the
column used as its Source must be in the source group or an ancestor of
the source group of the field's enclosing repeating frame.
The figure below shows a group tree. If the
source group of the repeating frame were 6, then the field Source could
be 1, 3, or 6. If the field has no enclosing repeating frame, the column
must be a report-level column, that is, it must be owned by the report.

- If a column has a Reset At of Page,
then any fields that use it as a source must be contained in repeating
frames that use the column's group as their source. In addition, any boilerplate
objects that reference the field must also be contained in repeating frames
that use the column's group as their source.
- If you specify
a Source for a field and later delete that source from your report (that is,
create a summary column, specify it as the source for a field, and later
delete that summary column), your field no longer has access to data to
display, and *UNDEFINED* appears in the Source field.
- If the Source of a field is &Logical
Page Number, &Panel Number,
&Physical Page Number, &Total Logical Pages, &Total
Panels, or &Total Physical
Pages, then any layout object that displays the field (either the
field itself or a boilerplate object) must have fixed sizing.
- A field cannot have a Source of Sound
or Video.
Example
Assume that you have a report with a data model like the one in the
figure. Assume further that G_Dept is the Source for repeating frame R_Dept
and G_Emp is the Source for repeating frame R_Emp.
In this example, DEPTNO and DNAME could be the Source for fields in either
R_Dept or R_Emp. ENAME and SAL could only be the Source for fields in R_Emp.

Copyright © 1984, 2005, Oracle. All rights reserved.