Get tally counts in different columns on your VISION:Results report

Products

• Vision:Results
• Vision:Sixty

Issue/Introduction

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

Resolution

Here is an example of how to code a simple 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