<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Scott, I would think that @sbrk1 would
only execute once at the start of the sub-total break level
defined for the sort (in the same way as @wbrk1). That would lead
me to think that if aa was global, it would hold the value you set
once in @sbrk1 until the next subtotal break(1) is reached. <br>
<br>
Bruce<br>
<br>
<br>
On 7/14/14 2:31 PM, <a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote
cite="mid:CADpQzqOT-8AfvtfUYi-2m1b=fY59F6mP=pVSpfmM9zC1r6_ZUg@mail.gmail.com"
type="cite">
<meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>If I make it global, then aa is always equal to ab....even
though it shouldn't be</div>
<div>the ending # is right on all of them, just not the starting
one</div>
<div>So making aa global makes aa=ab on all of them.....</div>
<div> </div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Jul 14, 2014 at 2:19 PM, Bruce
Easton <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:bruce@stn.com" target="_blank">bruce@stn.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote">Scott - maybe aa just needs to
be global (4,#,g).<br>
<br>
Bruce
<div>
<div class="h5"><br>
<br>
On 7/14/14 1:58 PM, <a moz-do-not-send="true"
href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>
wrote:<br>
</div>
</div>
<blockquote class="gmail_quote">
<div>
<div class="h5">
Oops - meant to only send that last email to you with
the processing in it<br>
- my mistake :(<br>
<br>
<br>
<br>
On Mon, Jul 14, 2014 at 1:57 PM, <a
moz-do-not-send="true"
href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>
<<a moz-do-not-send="true"
href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>><br>
wrote:<br>
<br>
<blockquote class="gmail_quote">
Ken,<br>
<br>
Here is what my output processing looks, with sort
on client number (4<br>
characters and subtotal) and then full account
number<br>
Everything works great except the 'starting
(lowest)' number - that is<br>
coming out blank<br>
<br>
:1="":end::gP*P|VW_L&4foSDs:<br>
@sbrk1::aa(4,#)=mid(3,"6","4") 'this is the lowest
number:<br>
@wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest
number:<br>
::lookup cli=client k=1 i=A -nx:<br>
::ac(30,uplow)=cli(2) ' this grabs the name of the
client:<br>
::end:<br>
<br>
My simple output on form just looks like this:<br>
<br>
Client Number: *1<br>
<br>
Client Name : *ac<br>
<br>
Starting # : *aa<br>
<br>
Ending # : *ab<br>
<br>
Total Records : *@rs<br>
<br>
<br>
Any idea why 'aa' starting number is coming back
blank?<br>
<br>
thanks<br>
<br>
Scott<br>
<br>
<br>
<br>
<br>
On Mon, Jul 14, 2014 at 10:51 AM, <a
moz-do-not-send="true"
href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>
<<a moz-do-not-send="true"
href="mailto:scooter6@gmail.com" target="_blank">scooter6@gmail.com</a>><br>
wrote:<br>
<br>
<blockquote class="gmail_quote">
Thanks Ken - I'll give that a shot<br>
<br>
<br>
On Mon, Jul 7, 2014 at 10:40 AM, Kenneth Brody
<<a moz-do-not-send="true"
href="mailto:kenbrody@spamcop.net"
target="_blank">kenbrody@spamcop.net</a>><br>
wrote:<br>
<br>
<blockquote class="gmail_quote">
On 7/2/2014 11:18 AM, <a moz-do-not-send="true"
href="mailto:scooter6@gmail.com"
target="_blank">scooter6@gmail.com</a> wrote:<br>
<br>
<blockquote class="gmail_quote">
A little stumped here<br>
I have a temp file we put records in during
day....and I'd like to<br>
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<br>
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>
<br>
</blockquote>
[...]<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",<br>
"5498"), with a subtotal break, followed by the
entire 9-digit number.<br>
This way, while you break on the 4-digit
client number, it will also be<br>
sorted by account number.<br>
<br>
Using @SBRK1, save the first (ie: "lowest")
account number for that<br>
client, using MID.<br>
<br>
Within @WBRK1, grab the account number, which
will be the "highest"<br>
number for that client. Then, @RS will be the
number of records for that<br>
account.<br>
<br>
You now have "# of records" (@RS), "starting
acct" (saved in @SBRK1),<br>
and "ending acct" (the "current" account number,
while in @WBRK1).<br>
<br>
--<br>
Kenneth Brody<br>
<br>
</blockquote>
<br>
</blockquote>
</blockquote>
</div>
</div>
<div>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
</div>
URL: <a moz-do-not-send="true"
href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/459ce583/attachment.html"
target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/459ce583/attachment.html</a>
<div>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com"
target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a moz-do-not-send="true"
href="http://mailman.celestial.com/mailman/listinfo/filepro-list"
target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
<br>
</div>
</blockquote>
<br>
<br>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>