<div dir="ltr">I guess that's the part I'm struggling with - since I'm using index for date, the first record it finds may not be the lowest number in that 'batch'<div>Would it be better to create an index on date and full account number, then grab the first 'acct'?</div><div>thanks</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jul 13, 2020 at 3:59 PM Bruce Easton via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Scott - if the only problem is the Starting Acct#, then, are you using a <br>
global field to track when the Starting Acct# is less than one <br>
previously encountered within a Ctl#?   (And then resetting it back to <br>
an arbitrarily high value when you start a new Ctl# after reporting the <br>
Ctl#?)<br>
<br>
Bruce<br>
<br>
<br>
On 7/13/20 2:12 PM, scooter6--- via Filepro-list wrote:<br>
> I have a database that has this type structure<br>
><br>
> Clt             Acct          Full Acct                  Date Received<br>
> -------         ---------      ----------------------<br>
>   -----------------------<br>
> 01234        00010      01234-00010          06/01/20<br>
> 01234        00011      01234-00011           06/01/20<br>
> 01234        00012      01234-00012           06/05/20<br>
> 01234        00013      01234-00013           06/10/20<br>
> 01235        00250      01235-00250           06/01/20<br>
> 01235        00251      01235-00251           06/05/20<br>
><br>
> I want to create a report with oldest received date first and a 'summary'<br>
> line for each batch then in Clt number order<br>
><br>
> For example, for the above data set, I want to see<br>
><br>
> Date Rec'd      Clt             Starting Acct      Ending Acct        Total<br>
> in Batch<br>
> ---------------      -----------    -----------------<br>
> ----------------         ------------------<br>
> 06/01/20           01234        00010               00011<br>
>           2<br>
> 06/01/20           01235        00250               00250<br>
>           1<br>
>                            Total Received 06/01/20<br>
>                3<br>
><br>
> 06/05/20           01234        00012               00012<br>
>           1<br>
> 06/05/20           01235        00251               00251<br>
>           1<br>
>                             Total Received 06/05/20<br>
>               2<br>
><br>
> 06/10/20           01234        00013               00013<br>
>           1<br>
>                              Total Received 06/10/20<br>
>                1<br>
><br>
><br>
> When I do @wbrk1 - I can get the Ending Account and the Total but even if I<br>
> declare the Starting Acct before @wbrk1 - both variables still come out the<br>
> same - so I'm apparently missing something there<br>
><br>
> I'm using sort order of Date Rec'd and descending and subtotal and subtotal<br>
> on Clt<br>
> Running this rreport with -ih  (index H which is Date Rec'd)<br>
><br>
> I can post full processing table if that helps - but each report dataline<br>
> is a field in the actual file<br>
> There is a little more I'm doing with it other than this, but it's really<br>
> just displaying a few of the other fields - so didn't want to confuse by<br>
> posting the full prc table<br>
><br>
> thanks<br>
> Scott<br>
> PDM<br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html</a>><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div>