How to get tally counts in different columns on your CA VISION:Results reports?

Document ID : KB000027967
Last Modified Date : 14/02/2018
Show Technical Document Details

Here is an example of how to code a simple CA VISION:Results program using the TALLYn keyword in the LIST statement to create unique columns of tally counts for each control break on your report.

FILE ARFILE
COPY ARFIELDS
REPORT 80 WIDE
CONTROL ACCTCODE
LIST SUPPRESS ACCTCODE (ACCOUNT) BALANCE E
ON CHANGE IN ACCTCODE
   LIST PRIOR ACCTCODE SUM BALANCE E TALLY1 WITH 2 BEFORE
ON FINAL
   LIST SUM BALANCE TALLY2 WITH 2 BEFORE AND 3 AFTER

This is an extract of report lines for the control break LIST statements:

    ACCOUNT        BALANCE             TALLY1         TALLY2
      BO                 44.99
 
      BO                 44.99              1
      EO                 32.00
                          5.00
                         15.00
                                                             
      EO                 52.00              3
 .   . 
 .   . 
 .   .
               
      WO  140.00
 .   .
 .   .
 .   .
                                                        
      WO                2,034.15             28
                                                       
                       19,023.10                          200