summary sheets from temp file

Bruce Easton bruce at stn.com
Mon Jul 14 12:47:24 PDT 2014


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.)

Bruce


On 7/14/14 3:12 PM, scooter6 at gmail.com wrote:
> Here is the 'structure' part of the file that's pertinent
> 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
> 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
> Field 3 = 9,allup  is the two fields combined  with a "-" in middle   
> 'i.e. 2435-0001, 2435-0002, 3194-0143, etc
> 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
>
>
> On Mon, Jul 14, 2014 at 3:04 PM, Bruce Easton <bruce at stn.com 
> <mailto:bruce at stn.com>> wrote:
>
>     Scott - check the sort screen for this - did you sort on Account
>     Number,
>     but only for a length of four?
>
>     Bruce
>
>     On 7/14/14 2:55 PM, scooter6 at gmail.com <mailto:scooter6 at gmail.com>
>     wrote:
>     > adding 'end' in @sbrk1 had no effect - aa is still equal to ab
>     on all
>     > pages
>     >
>     >
>     > On Mon, Jul 14, 2014 at 2:47 PM, Bruce Easton <bruce at stn.com
>     <mailto:bruce at stn.com>
>     > <mailto:bruce at stn.com <mailto:bruce at stn.com>>> wrote:
>     >
>     >     Ah yes, the lack of "end" for @sbrk1 is probably why your aa
>     is being
>     >     set to your ab.
>     >
>     >     Bruce
>     >
>     >     On 7/14/14 2:33 PM, Kenneth Brody wrote:
>     >     > On 7/14/2014 1:57 PM, scooter6 at gmail.com
>     <mailto:scooter6 at gmail.com>
>     >     <mailto:scooter6 at gmail.com <mailto:scooter6 at gmail.com>> wrote:
>     >     >> Ken,
>     >     >>
>     >     >> Here is what my output processing looks, with sort on client
>     >     number (4
>     >     >> characters and subtotal) and then full account number
>     >     >> Everything works great except the 'starting (lowest)'
>     number -
>     >     that is
>     >     >> coming out blank
>     >     >>
>     >     >> :1="":end::gP*P|VW_L&4foSDs:
>     >     >> @sbrk1::aa(4,#)=mid(3,"6","4")  'this is the lowest number:
>     >     > aa(4,#,g)=mid(3,"6","4") ; end
>     >     >
>     >     >> @wbrk1::ab(4,#)=mid(3,"6","4") 'this is the highest number:
>     >     >> ::lookup cli=client  k=1   i=A -nx:
>     >     >> ::ac(30,uplow)=cli(2) ' this grabs the name of the client:
>     >     >> ::end:
>     >     > [...]
>     >     >> Any idea why 'aa' starting number is coming back blank?
>     >     > [...]
>     >     >
>     >     > No ",g" flag.
>     >     >
>     >
>     >
>     >     _______________________________________________
>     >     Filepro-list mailing list
>     > Filepro-list at lists.celestial.com
>     <mailto:Filepro-list at lists.celestial.com>
>     >     <mailto:Filepro-list at lists.celestial.com
>     <mailto:Filepro-list at lists.celestial.com>>
>     >     Subscribe/Unsubscribe/Subscription Changes
>     > http://mailman.celestial.com/mailman/listinfo/filepro-list
>     >
>     >
>
>     -------------- next part --------------
>     An HTML attachment was scrubbed...
>     URL:
>     http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/c48dae8d/attachment.html
>     _______________________________________________
>     Filepro-list mailing list
>     Filepro-list at lists.celestial.com
>     <mailto:Filepro-list at lists.celestial.com>
>     Subscribe/Unsubscribe/Subscription Changes
>     http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/836a6b5a/attachment.html 


More information about the Filepro-list mailing list