Help on Report

[Bruce Easton]

Scott - if the only problem is the Starting Acct#, then, are you using a 
global field to track when the Starting Acct# is less than one 
previously encountered within a Ctl#?   (And then resetting it back to 
an arbitrarily high value when you start a new Ctl# after reporting the 
Ctl#?)

Bruce


On 7/13/20 2:12 PM, scooter6--- via Filepro-list wrote:
> 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>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list