<div dir="ltr"><div>Should my output format be 'subtotaled' on BOTH client number AND full account number?</div><div>Currently it's only subtotaled once in Sort options....</div></div><div class="gmail_extra"><br>
<br><div class="gmail_quote">On Mon, Jul 14, 2014 at 2:43 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, I would think that @sbrk1 would only execute once at the start of<br>
the sub-total break level defined for the sort (in the same way as<br>
@wbrk1). That would lead me to think that if aa was global, it would<br>
hold the value you set once in @sbrk1 until the next subtotal break(1)<br>
is reached.<br>
<br>
Bruce<br>
<div><br>
<br>
On 7/14/14 2:31 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a> wrote:<br>
> If I make it global, then aa is always equal to ab....even though it<br>
> shouldn't be<br>
> the ending # is right on all of them, just not the starting one<br>
> So making aa global makes aa=ab on all of them.....<br>
><br>
><br>
> On Mon, Jul 14, 2014 at 2:19 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 - maybe aa just needs to be global (4,#,g).<br>
><br>
> Bruce<br>
><br>
><br>
</div>> On 7/14/14 1:58 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>
><br>
> Oops - meant to only send that last email to you with the<br>
> processing in it<br>
> - my mistake :(<br>
><br>
><br>
><br>
> On Mon, Jul 14, 2014 at 1:57 PM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
</div>> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>> <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>>><br>
<div>> wrote:<br>
><br>
> Ken,<br>
><br>
> Here is what my output processing looks, with sort on<br>
> client number (4<br>
> characters and subtotal) and then full account number<br>
> Everything works great except the 'starting (lowest)'<br>
> 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 href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
</div>> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>> <<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>>><br>
<div>> wrote:<br>
><br>
> Thanks Ken - I'll give that a shot<br>
><br>
><br>
> On Mon, Jul 7, 2014 at 10:40 AM, Kenneth Brody<br>
</div>> <<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a> <mailto:<a href="mailto:kenbrody@spamcop.net">kenbrody@spamcop.net</a>>><br>
<div>> wrote:<br>
><br>
> On 7/2/2014 11:18 AM, <a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a><br>
</div><div><div class="h5">> <mailto:<a href="mailto:scooter6@gmail.com">scooter6@gmail.com</a>> wrote:<br>
><br>
> A little stumped here<br>
> I have a temp file we put records in during<br>
> day....and I'd like to<br>
> print a<br>
> summary 'cover sheet' nightly based on what is<br>
> in this file<br>
><br>
> So I have records that will look like this<br>
> (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'<br>
> (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<br>
> client file using 2435 and<br>
> grab the client name)<br>
> # of Records : 2 (this should count<br>
> 2435-0001 & 2435-0002 and<br>
> total unique records)<br>
> Starting acct : 0001 (lowest 'acct' for<br>
> 2435)<br>
> Ending acct : 0002 (highest 'acct' for<br>
> 2435)<br>
><br>
> [...]<br>
><br>
> There are several ways I see to do this. Here is<br>
> one method:<br>
><br>
> Sort on the first 4 digits of the client number<br>
> (ie: "2345", "3194",<br>
> "5498"), with a subtotal break, followed by the<br>
> entire 9-digit number.<br>
> This way, while you break on the 4-digit client<br>
> number, it will also be<br>
> sorted by account number.<br>
><br>
> Using @SBRK1, save the first (ie: "lowest")<br>
> account number for that<br>
> client, using MID.<br>
><br>
> Within @WBRK1, grab the account number, which will<br>
> be the "highest"<br>
> number for that client. Then, @RS will be the<br>
> number of records for that<br>
> account.<br>
><br>
> You now have "# of records" (@RS), "starting acct"<br>
> (saved in @SBRK1),<br>
> and "ending acct" (the "current" account number,<br>
> while in @WBRK1).<br>
><br>
> --<br>
> Kenneth Brody<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/459ce583/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/459ce583/attachment.html</a><br>
><br>
><br>
> _______________________________________________<br>
> Filepro-list mailing list<br>
> <a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
</div></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>
><br>
<div><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
</div>URL: <a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/ad3dc2d2/attachment.html" target="_blank">http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/ad3dc2d2/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>