<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, for the report to do what you
need it to do, I would think you want it in client, then account
order (so that it hits the lowest acct# first and the highest last
within a client). If you look back at Ken's initial reply on
this, his first paragraph gives the answer, but, based on what we
knew at that time, we only knew about the one combined field
(which seems to be field #3). So with those dummy fields global
and "end"ing the @sbrk1 section, it should work the way he
described if you sort on your field 3, but overriding the length
of the sort to be 4. (Also, since we now know you have the other
parts of the key stored separately, you could alternatively make
the sort composite and sort on all of field 1 and then at the next
level on all of field 2 and only specify to sub-total break (with
the "x") on the level that's on field 1.)<br>
<br>
Bruce<br>
<br>
<br>
On 7/14/14 3:12 PM, <a class="moz-txt-link-abbreviated" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div>
<blockquote
cite="mid:CADpQzqOvVJKq6KWiVwbW3PoVCBViKk3bGrMn_5UfYZFxrSiv9A@mail.gmail.com"
type="cite">
<meta http-equiv="Context-Type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Here is the 'structure' part of the file that's pertinent</div>
<div> </div>
<div>Field 1 = 4,# is the client number ' in the examples
here, that is 2435, 3194 & 5498 - this is what it should
sort on - a new page for each unique client number</div>
<div>Field 2 = 4,allup is the account number 'in the examples
here, that is what comes after the "-" 0001, 0002 for client
2435, 0143, 0144, 0145 for client 3194</div>
<div>Field 3 = 9,allup is the two fields combined with a "-"
in middle 'i.e. 2435-0001, 2435-0002, 3194-0143, etc</div>
<div> </div>
<div>So since the file has the client number in a field already,
I have it sorting on field 1 with a length of 4 - which
appears to be okay, since it's doing what I want it to do,
except it's not finding the 'lowest' account
number...otherwise, everything works fine haha</div>
<div> </div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Jul 14, 2014 at 3:04 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 - check the sort screen
for this - did you sort on Account Number,<br>
but only for a length of four?<br>
<br>
Bruce<br>
<div><br>
On 7/14/14 2:55 PM, <a moz-do-not-send="true"
href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>
wrote:<br>
> adding 'end' in @sbrk1 had no effect - aa is still
equal to ab on all<br>
> pages<br>
><br>
><br>
> On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <<a
moz-do-not-send="true" href="mailto:bruce@stn.com">bruce@stn.com</a><br>
</div>
<div>> <mailto:<a moz-do-not-send="true"
href="mailto:bruce@stn.com">bruce@stn.com</a>>>
wrote:<br>
><br>
> Ah yes, the lack of "end" for @sbrk1 is probably
why your aa is being<br>
> set to your ab.<br>
><br>
> Bruce<br>
><br>
> On 7/14/14 2:33 PM, Kenneth Brody wrote:<br>
> > On 7/14/2014 1:57 PM, <a
moz-do-not-send="true" href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
</div>
<div>> <mailto:<a moz-do-not-send="true"
href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>>
wrote:<br>
> >> Ken,<br>
> >><br>
> >> Here is what my output processing looks,
with sort on client<br>
> number (4<br>
> >> characters and subtotal) and then full
account number<br>
> >> Everything works great except the
'starting (lowest)' number -<br>
> 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>
> > aa(4,#,g)=mid(3,"6","4") ; end<br>
> ><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>
> >> Any idea why 'aa' starting number is
coming back blank?<br>
> > [...]<br>
> ><br>
> > No ",g" flag.<br>
> ><br>
><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
</div>
> <mailto:<a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com">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>
><br>
<div><br>
-------------- 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/c48dae8d/attachment.html"
target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/c48dae8d/attachment.html</a><br>
<div class="HOEnZb">
<div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a moz-do-not-send="true"
href="mailto:Filepro-list@lists.celestial.com">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>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>