The VM Interface › Reporting Component › Report Control Statements › Grouping Feature Example 3

Grouping Feature Example 3

Request

A computer billing report with special rates for each of 3 account numbers:

AAA
BBB        different rates for each
CCC

Build GROUP and GROUPC statements as follows:

points to Accounting Field information in Basic Accounting Table ▼

 CGROUP   0773   < select all records

     CGROUPC  1AAA              X < CPU ID for records
                                   with account #AAA

     CGROUPC  1BBB              Y < CPU ID for records
                                   with account #BBB

     CGROUPC  1CCC              Z < CPU ID for records
                                   with account #CCC

Example 3 shows you how to use the Grouping feature to dynamically change the CPU Identification code in specific accounting records based on their associated account number. This example assumes that the first three characters of the accounting fields information holds an account number.

The Selection/Rejection Indicator is blank, causing all records to be selected since no grouping is required for this report. The CPU Identification codes on all qualified records are changed as designated by the GROUPC statements. All unidentified record groups remain unchanged. You could then define separate accounting algorithms on different VMRATE statements to correspond to the newly created CPU Identification codes in addition to other algorithms normally used.