<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Wait, I understood that using -i[?] simply meant that one can use
the -v processing to perform lookup thus reduce the process by
directing pointer to the block of records you are interested in.</p>
<p>Are you saying that using -i[?] means that run time will use the
given index.[?] as source of data in lieu of key?<br>
</p>
<p>Based on my understanding, there is no reason to invoke -i[?]
unless you are performing lookup - to move record pointer. BTW,
this technique runs through thousands of records and retrieves a
block of them in a blink of an eye - hence the blessings realized
when filePro increased the number of automatic indexes.</p>
<p>Back to OP: Have you resolved your issue? Still looking for a
solution?</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 7/15/20 11:07 AM, <a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqM3XyEhiGz--o6r+nzxvszUP=+P5wP8HoGjqEKqHWTriA@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote>
</div>
</blockquote>
</body>
</html>