<div dir="ltr">Yes rreport client -f summary -u -a -v select -ih with index H being received date</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Jul 15, 2020 at 11:04 AM Richard Kreiss via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">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">Are you using a -v selection process?<br>
<br>
I am going to assume that you are already indicating the index mentioned on the command line. Is this assumption correct?<br>
<br>
<br>
<br>
Richard<br>
Sent from my iPhone<br>
<br>
> On Jul 15, 2020, at 7:32 AM, Jose Lerebours via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote:<br>
> <br>
> Call me crazy but doesn't filePro allow for the "sort" to be changed from within the -v processing table?<br>
> <br>
> If that is the case, will not work if you<br>
> <br>
> a. convert date into a YY-MM-DD format<br>
> b. create string like so DATE + CONTROL + [ whatever ]<br>
> <br>
> use filePro available method to set the sort order. By the time your processing triggers, your data should be in the order you desire.<br>
> <br>
> If filePro does observe the "date" field as a "date" and not as string when sorting, I fail to see how this cannot be done using standard sort settings ASC/DES combination. Of course, if your fields are not in sequence, using the -v table might be the way to go.<br>
> <br>
> <br>
>> On 7/15/20 6:03 AM, Jeff Harrison via Filepro-list wrote:<br>
>> It's been a while, but I think that you can leverage the min and max functions for this.<br>
>> In your processing at line 1 (before the @brk) do something like ;Aa=min(acctfield) ; ab=max(acctfield)<br>
>> Now you can reference aa and ab when you are at the break and will have the expected values.<br>
>> <br>
>> Sent from Yahoo Mail on Android<br>
>> On Wed, Jul 15, 2020 at 1:59 AM, scooter6--- via Filepro-list<<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote: I guess that's the part I'm struggling with - since I'm using index for<br>
>> date, the first record it finds may not be the lowest number in that 'batch'<br>
>> Would it be better to create an index on date and full account number, then<br>
>> grab the first 'acct'?<br>
>> thanks<br>
>> <br>
>> <br>
>> On Mon, Jul 13, 2020 at 3:59 PM Bruce Easton via Filepro-list <<br>
>> <a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>> wrote:<br>
>> <br>
>>> 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<br>
>>> 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<br>
>>> if I<br>
>>>> declare the Starting Acct before @wbrk1 - both variables still come out<br>
>>> 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<br>
>>> 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: <<br>
>>> <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>
>>> 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>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200714/670932b6/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200714/670932b6/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>
>> -------------- next part --------------<br>
>> An HTML attachment was scrubbed...<br>
>> URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200715/5a657b03/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20200715/5a657b03/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>
> 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>
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>