The Reset At property specifies the group at which the summary column value resets to zero (if Function is Count), null (if Function is not Count), or Value If Null (if the column has a null value). Reset At has a list of values containing valid reset groups. Reset At determines if the summary is a running summary or a periodic (for example, group-level) summary.
Applies to |
Summary columns | ||||||
Values |
| ||||||
Required/Optional |
Required, for columns of type Summary. |
Reset At is only editable for summary columns.
Summary columns that are owned by a cross-product group cannot have a Reset At setting of Page.
If a summary has a Reset At setting of Page, then the sizing of the field or boilerplate object that displays it must be fixed.
If a column has a Reset At setting 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.
A Reset At setting of Page will not work for reports that have multiple repeating frames associated with a group that is involved in the summary. One common case of this is a matrix report. As a result, matrix reports cannot have page-level summaries.
For multiple summary columns that are in child groups that share the same parent group, a Reset At setting of Page may produce incorrect results.
If your data model contains multiple child groups with a shared parent (for example, master-detail-detail), summary columns with a Reset At setting of Page may give unexpected results.
The reset group of a summary column may be its group or any group above its group, including Report and Page.
To ensure that page summaries behave in a predictable way, make sure each record fits on a single page, or if that is not feasible, force each new record to print on a new page.
Suppose that you want to create a group report like the one below:
DEPT NAME SAL RESETSUM RUNSUM
---- -------- ---- -------- ------
10 SMITH 1000 1000 1000
JONES 1000 2000 2000
KING 1000 3000 3000
20 JOHNSON 1500 1500 4500
WARD 1000 2500 5500
The parent group, G_DEPT
, contains the DEPTNO
column.
The child group, G_EMP
, contains ENAME
and SAL
.
To get the sum of salaries for each department (RESETSUM
), you
create a summary column in G_EMP
with the following settings
Function |
Reset At |
Sum |
G_DEPT |
In this case, Reset At indicates that the summary should be set to null after each department.
To get the running sum of salaries (RUNSUM
), you create a summary
column in G_EMP
with the following settings:
Function |
Reset At |
Sum |
Report |
In this case, Reset At indicates that the summary should not be reset to null but should accumulate throughout the report.
Copyright © 1984, 2005, Oracle. All rights reserved.