Help on Report

[scooter6 at gmail.com]

I have a database that has this type structure

Clt             Acct          Full Acct                  Date Received
-------         ---------      ----------------------
 -----------------------
01234        00010      01234-00010          06/01/20
01234        00011      01234-00011           06/01/20
01234        00012      01234-00012           06/05/20
01234        00013      01234-00013           06/10/20
01235        00250      01235-00250           06/01/20
01235        00251      01235-00251           06/05/20

I want to create a report with oldest received date first and a 'summary'
line for each batch then in Clt number order

For example, for the above data set, I want to see

Date Rec'd      Clt             Starting Acct      Ending Acct        Total
in Batch
---------------      -----------    -----------------
----------------         ------------------
06/01/20           01234        00010               00011
         2
06/01/20           01235        00250               00250
         1
                          Total Received 06/01/20
              3

06/05/20           01234        00012               00012
         1
06/05/20           01235        00251               00251
         1
                           Total Received 06/05/20
             2

06/10/20           01234        00013               00013
         1
                            Total Received 06/10/20
              1


When I do @wbrk1 - I can get the Ending Account and the Total but even if I
declare the Starting Acct before @wbrk1 - both variables still come out the
same - so I'm apparently missing something there

I'm using sort order of Date Rec'd and descending and subtotal and subtotal
on Clt
Running this rreport with -ih  (index H which is Date Rec'd)

I can post full processing table if that helps - but each report dataline
is a field in the actual file
There is a little more I'm doing with it other than this, but it's really
just displaying a few of the other fields - so didn't want to confuse by
posting the full prc table

thanks
Scott
PDM
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html>