<div dir="ltr"><div>Seems to me it's going thru @sbrk1 after each record.....I put a 'beep;msgbox...' statement in @sbrk as shown and it increases each time I hit enter</div><div>Here are the records I have in the file:</div>
<div> </div><div>2435-0126</div><div>3194-0143</div><div>3194-0144</div><div>3194-0145</div><div>3981-0059</div><div>5499-0086</div><div>5499-0087</div><div>5499-0088</div><div>5499-0090</div><div>5499-0091</div><div> </div>
<div>So my processing now looks like this:</div><div> </div><div>:1="":end::</div><div>@sbrk1::aa(4,#,g)=mid(3,"6","4");beep;msgbox "Value of aa is"<aa 'this is the lowest acct number:</div>
<div>::end:</div><div>@wbrk1::ab(4,#,g)=mid(3,"6","4") 'this is the highest acct number:</div><div>::lookup cli = client k=1 i=A -nx:</div><div>::ac(30,uplow)=cli(2) :</div><div>::end:</div><div>
</div><div>I have tried this with both ",g" and without ",g"</div><div>If I use ",g" then aa and ab are always the same (the highest number, ab)</div><div>If I don't use ",g" then aa is always black, but ab is correct</div>
<div> </div><div>My sort information is:</div><div> </div><div> Sort field : 1 | 2</div><div> Length : 4 | 4</div><div> Descending: |</div><div>Subtotal field: x |</div><div> </div><div>
When I run this on all records, the msgbox I get happens in this order (after each record, it's giving me the value of the acct number)</div><div> </div><div>Value of aa is 0126 I hit enter, still shows</div><div>Value of aa is 0126 then it prints the page</div>
<div> </div><div>Value of aa is 0143 I hit enter</div><div>Value of aa is 0144 I hit enter</div><div>Value of aa is 0145 I hit enter and it prints the page</div><div> </div><div>Value of aa is 0059 I hit enter, still shows</div>
<div>Value of aa is 0059 I hit enter and it prints the page</div><div> </div><div>Value of aa is 0086 I hit enter, still shows</div><div>Value of aa is 0086 I hit enter, shows</div><div>Value of aa is 0087 I hit enter, shows</div>
<div>Value of aa is 0088 I hit enter, shows</div><div>Value of aa is 0090 I hit enter, shows</div><div>Value of aa is 0091 I hit enter and it prints the page</div><div> </div><div>Processing ends......</div><div> </div>
<div>Not sure why aa would return different values each time I hit enter, if in fact the subtotal is on client number....should only hit @sbrk1 when it reaches a different client number, right??</div><div> </div><div> </div>
<div> </div><div> </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Jul 14, 2014 at 3:47 PM, Bruce Easton <span dir="ltr"><<a href="mailto:bruce@stn.com" target="_blank">bruce@stn.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Scott, for the report to do what you need it to do, I would think you<br>
want it in client, then account order (so that it hits the lowest acct#<br>
first and the highest last within a client). If you look back at Ken's<br>
initial reply on this, his first paragraph gives the answer, but, based<br>
on what we knew at that time, we only knew about the one combined field<br>
(which seems to be field #3). So with those dummy fields global and<br>
"end"ing the @sbrk1 section, it should work the way he described if you<br>
sort on your field 3, but overriding the length of the sort to be 4.<br>
(Also, since we now know you have the other parts of the key stored<br>
separately, you could alternatively make the sort composite and sort on<br>
all of field 1 and then at the next level on all of field 2 and only<br>
specify to sub-total break (with the "x") on the level that's on field 1.)<br>
<div><br>
Bruce<br>
<br>
<br>
On 7/14/14 3:12 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
</div><div>> Here is the 'structure' part of the file that's pertinent<br>
> Field 1 = 4,# is the client number ' in the examples here, that is<br>
> 2435, 3194 & 5498 - this is what it should sort on - a new page for<br>
> each unique client number<br>
> Field 2 = 4,allup is the account number 'in the examples here, that<br>
> is what comes after the "-" 0001, 0002 for client 2435, 0143, 0144,<br>
> 0145 for client 3194<br>
> Field 3 = 9,allup is the two fields combined with a "-" in middle<br>
> 'i.e. 2435-0001, 2435-0002, 3194-0143, etc<br>
> So since the file has the client number in a field already, I have it<br>
> sorting on field 1 with a length of 4 - which appears to be okay,<br>
> since it's doing what I want it to do, except it's not finding the<br>
> 'lowest' account number...otherwise, everything works fine haha<br>
><br>
><br>
> On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <<a href="mailto:bruce@stn.com">bruce@stn.com</a><br>
</div><div>> <mailto:<a href="mailto:bruce@stn.com">bruce@stn.com</a>>> wrote:<br>
><br>
> Scott - check the sort screen for this - did you sort on Account<br>
> Number,<br>
> but only for a length of four?<br>
><br>
> Bruce<br>
><br>
</div>> On 7/14/14 2:55 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
<div>> wrote:<br>
> > adding 'end' in @sbrk1 had no effect - aa is still equal to ab<br>
> on all<br>
> > pages<br>
> ><br>
> ><br>
> > On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <<a href="mailto:bruce@stn.com">bruce@stn.com</a><br>
> <mailto:<a href="mailto:bruce@stn.com">bruce@stn.com</a>><br>
</div><div>> > <mailto:<a href="mailto:bruce@stn.com">bruce@stn.com</a> <mailto:<a 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<br>
> 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 href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>><br>
</div><div>> > <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> <mailto:<a 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)'<br>
> 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 href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> <mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>><br>
</div>> > <mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
<div>> <mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>>><br>
> > Subscribe/Unsubscribe/Subscription Changes<br>
> > <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
> ><br>
> ><br>
><br>
> -------------- next part --------------<br>
> An HTML attachment was scrubbed...<br>
> URL:<br>
> <a 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>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
> <mailto:<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>><br>
> Subscribe/Unsubscribe/Subscription Changes<br>
> <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
><br>
><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
</div>URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/836a6b5a/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/836a6b5a/attachment.html</a><br>
<div class="HOEnZb"><div class="h5">_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a 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>