How To Use Multiple Verbs

Most report requests can be generated using a single verb, but it's possible to use up to 16 verbs and their associated sort conditions. Multiple verbs (also known as display commands) can be used to summarize several levels of data, or to display summary data and detail data in one report. The rules for using multiple verbs are:

 

  • Aggregate verbs (SUM or COUNT) must be used before detail verbs (PRINT or LIST).

  • If more than 2 verbs are used, only the last verb may be a detail verb.

  • The first verb phrase does not require a sort condition.

  • When a sort phrase is used with a verb phrase, any subsequent verb phrases must use the same sorting condition in the same order.

  • WHERE and IF conditions apply to the records selected for the report as a whole.

Example 1

The sample report below uses 3 instances of the verb SUM to calculate multiple levels of salary detail. The first verb phrase SUM AC:SALARY does not require a sort condition and calculates the total amount of salaries; the second verb phrase SUM AC:SALARY BY AC:UNIT calculates the total amounts of current salaries in each reporting unit; the second verb phrase SUM AC:SALARY BY AC:UNIT BY AC:WNAME  calculates the total amounts of current salaries for each employee in each reporting unit.  Note that for the last verb phrase, the sort phrase BY AC:UNIT must be repeated before the sort phrase BY AC:WNAME is used.   

 

Report Request:

Report Generated:

EX AC

TABLE FILE AC

SUM AC:SALARY

SUM AC:SALARY BY AC:UNIT

SUM AC:SALARY BY AC:UNIT BY AC:WNAME

END

 ac:salary  UNT    ac:salary   ac:wname        ac:salary

 ---------  ---    ---------   --------        ---------

$29,522.00  100   $19,756.00   Camel, SUE     $14,417.00

                               dog, jan        $5,339.00

            200    $9,766.00   Bear, bob       $4,570.00

                               HIPPO, JIM      $5,196.00      

Example 2

The sample report below uses 2 verbs to provide summary and detail information on employee positions.   The first verb phrase COUNT AC:POSIT16 has an associated sort phrase BY AC:UNIT and provides the total number of positions by individual reporting units.  The second verb phrase, PRINT AC:SSA AC:WNAME AC:POSIT16 provides detailed information on the employees and their position number and must repeat the sort phrase BY AC: UNIT used for the first verb phrase. Note that PRINT must be used as the last verb phrase because it is a detail verb.  

 

Report Request:

Report Generated:

EX AC

TABLE FILE AC

COUNT AC:POSIT16

  BY AC:UNIT

PRINT ac:SSA AC:WNAME AC:posit16

  BY AC:UNIT    

END

     ac:position

UNT  count         ac:wname      ac:posit16

---  -----------   ---------     ----------

100  3             camel, sue    999-100-0820-000

                   camel, sue    999-100-1619-000

                   dog, jan      999-100-3300-000  

200  2             bear, bob     999-200-2358-000

                   hippo, jim    999-200-0400-000

 

Related topic:  Sample Request: Count and List of Employees