<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Scott,<br>
<br>
This "should" do it. (see below)<br>
<br>
Richard D. Williams<br>
(713) 931-9938<br>
<br>
<font face="Courier New, Courier, monospace"> 1 ------- - -
- - - - - - - - - - - - - -<br>
If: 'fields - 1 clt#, 2 acct#, 3 full acct#, 4 date<br>
Then:<br>
2 ------- - - - - - - - - - - - - -
- - -<br>
If: 'set sub-total by date and then clt#<br>
Then:<br>
3 ------- - - - - - - - - - - - - -
- - -<br>
If: 'in the date sub-total area use @RS to count how many<br>
Then: 'record were reported on that date<br>
4 ------- - - - - - - - - - - - - -
- - -<br>
If: 'in the clt# sub-total area put the variables for<br>
Then: 'the lowest acct# - la and the highest acct# lb<br>
5 ------- - - - - - - - - - - - - -
- - -<br>
If: '<br>
Then: '<br>
6 ------- - - - - - - - - - - - - -
- - -<br>
If: 'ca keeps track when the date changes and resets the<br>
Then: 'lowest & highest acct numbers#<br>
7 ------- - - - - - - - - - - - - -
-<br>
If: ca ne 4<br>
Then: ca(8,mdy/,g)=4;la="";lb=""<br>
8 ------- - - - - - - - - - - - - -
-<br>
If: 'cn keeps track when the clt3 changes and resets the<br>
Then: 'lowest & highest acct numbers#<br>
9 ------- - - - - - - - - - - - - -
-<br>
If: cn ne 1<br>
Then: cn(5,#,g)=1;la(5,#,g)="";lb(5,#,g)=""<br>
10 ------- - - - - - - - - - - - - -
-<br>
If: la lt 2<br>
Then: la=4<br>
11 ------- - - - - - - - - - - - - -
-<br>
If: 2 gt lb<br>
Then: lb=4<br>
12 ------- - - - - - - - - - - - - -
-<br>
end If:<br>
Then: end</font><br>
<br>
<div class="moz-cite-prefix">On 7/13/2020 1:12 PM, scooter6--- via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CADpQzqN0uL=ch2boO8qoHGCyAjaGny9rgFOXmdBbU0ZCi9hW3g@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">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: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20200713/7231d1b1/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
</body>
</html>