<div dir="ltr"><div>Ken, </div><div> </div><div>Here is what my output processing looks, with sort on client number (4 characters and subtotal) and then full account number</div><div>Everything works great except the 'starting (lowest)' number - that is coming out blank</div>
<div> </div><div>:1="":end::gP*P|VW_L&4foSDs:</div><div>@sbrk1::aa(4,#)=mid(3,"6","4") 'this is the lowest number:</div><div>@wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:</div>
<div>::lookup cli=client k=1 i=A -nx:</div><div>::ac(30,uplow)=cli(2) ' this grabs the name of the client:</div><div>::end:</div><div> </div><div>My simple output on form just looks like this:</div><div> </div><div>
Client Number: *1</div><div> </div><div>Client Name : *ac</div><div> </div><div>Starting # : *aa</div><div> </div><div>Ending # : *ab</div><div> </div><div>Total Records : *@rs</div><div> </div><div>
</div><div>Any idea why 'aa' starting number is coming back blank?</div><div> </div><div>thanks</div><div> </div><div>Scott</div><div> </div><div> </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
On Mon, Jul 14, 2014 at 10:51 AM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <span dir="ltr"><<a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Thanks Ken - I'll give that a shot</div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 7, 2014 at 10:40 AM, Kenneth Brody <span dir="ltr"><<a href="mailto:kenbrody@spamcop.net" target="_blank">kenbrody@spamcop.net</a>></span> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote"><div>On 7/2/2014 11:18 AM, <a href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a> wrote:<br>
<blockquote style="margin:0px 0px 0px 0.8ex;padding-left:1ex;border-left-color:rgb(204,204,204);border-left-width:1px;border-left-style:solid" class="gmail_quote">
A little stumped here<br>
I have a temp file we put records in during day....and I'd like to print a<br>
summary 'cover sheet' nightly based on what is in this file<br>
<br>
So I have records that will look like this (all based on client number,<br>
which is first 4 numbers of our 'Account Number')<br>
<br>
2435-0001 John Smith<br>
2435-0002 Jane Doe<br>
3194-0143 John Consumer<br>
3194-0144 Billy Carter<br>
3194-0145 Ronald Reagan<br>
5498-0254 George Bush<br>
5498-0255 Bill Clinton<br>
<br>
So, at night, I want to print 3 'CoverSheets' (one for each unique client<br>
number: 2435, 3194 & 5498)<br>
<br>
The CoverSheet report will basically say:<br>
<br>
Client Number: 2435<br>
Client Name : *aa (this will lookup the client file using 2435 and<br>
grab the client name)<br>
# of Records : 2 (this should count 2435-0001 & 2435-0002 and<br>
total unique records)<br>
Starting acct : 0001 (lowest 'acct' for 2435)<br>
Ending acct : 0002 (highest 'acct' for 2435)<br>
</blockquote></div>
[...]<br>
<br>
There are several ways I see to do this. Here is one method:<br>
<br>
Sort on the first 4 digits of the client number (ie: "2345", "3194", "5498"), with a subtotal break, followed by the entire 9-digit number. This way, while you break on the 4-digit client number, it will also be sorted by account number.<br>
<br>
Using @SBRK1, save the first (ie: "lowest") account number for that client, using MID.<br>
<br>
Within @WBRK1, grab the account number, which will be the "highest" number for that client. Then, @RS will be the number of records for that account.<br>
<br>
You now have "# of records" (@RS), "starting acct" (saved in @SBRK1), and "ending acct" (the "current" account number, while in @WBRK1).<span><font color="#888888"><br>
<br>
-- <br>
Kenneth Brody<br>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br></div>