A script-enabled browser is required for this page to function properly.

Reset At property

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

Page

Is used for page-level summaries. The summary is reset between pages.

Report

Is used for summaries that apply to the entire report, such as grand totals. The summary is reset after the report (that is, it is never reset).

group_name

Is a valid group name. The summary is reset after each record of the group.

Required/Optional

Required, for columns of type Summary.

Restrictions

Usage notes

Example

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.

See also

About summary columns