The NUMDETAIL Function

4 Functions

The NUMDETAIL Function

The NUMDETAIL function returns the number of DETAIL LINE statements (with number between one and nine) executed since the header statement at the specified level was executed. The number is incremented during execution of a DETAIL LINE (1-9) statement after all breaks are serviced but before control is passed to the USING part of the statement. When a level break occurs, the number is zeroed before control is passed to the associated HEADER but remains available and unchanged in all TRAILERS.

NUMDETAIL (level)

The parameter is:

level: A numeric expression that evaluates to an integer from 0 to 9. It associates the NUMDETAIL with the header statement of the same level. If set to 0, the total number of detail lines (with number between one and nine) executed since the report became active is returned.

An example of this function follows.


60   HEADER 1
70     TOTALS ON Qty*Price
.
.
.
260  TRAILER 1 USING R_trail;TOTAL(1,1)/NUMDETAIL(1)

Eloquence Report Manual - 19 DEC 2002