summary sheets from temp file

Bruce Easton bruce at stn.com
Mon Jul 14 11:43:34 PDT 2014


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.

Bruce


On 7/14/14 2:31 PM, scooter6 at gmail.com wrote:
> If I make it global, then aa is always equal to ab....even though it 
> shouldn't be
> the ending # is right on all of them, just not the starting one
> So making aa global makes aa=ab on all of them.....
>
>
> On Mon, Jul 14, 2014 at 2:19 PM, Bruce Easton <bruce at stn.com 
> <mailto:bruce at stn.com>> wrote:
>
>     Scott - maybe aa just needs to be global (4,#,g).
>
>     Bruce
>
>
>     On 7/14/14 1:58 PM, scooter6 at gmail.com <mailto:scooter6 at gmail.com>
>     wrote:
>
>         Oops - meant to only send that last email to you with the
>         processing in it
>         - my mistake :(
>
>
>
>         On Mon, Jul 14, 2014 at 1:57 PM, scooter6 at gmail.com
>         <mailto:scooter6 at gmail.com> <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:
>             @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:
>
>             My simple output on form just looks like this:
>
>             Client Number:  *1
>
>             Client Name   :  *ac
>
>             Starting #        :  *aa
>
>             Ending #         :  *ab
>
>             Total Records :  *@rs
>
>
>             Any idea why 'aa' starting number is coming back blank?
>
>             thanks
>
>             Scott
>
>
>
>
>             On Mon, Jul 14, 2014 at 10:51 AM, scooter6 at gmail.com
>             <mailto:scooter6 at gmail.com> <scooter6 at gmail.com
>             <mailto:scooter6 at gmail.com>>
>             wrote:
>
>                 Thanks Ken - I'll give that a shot
>
>
>                 On Mon, Jul 7, 2014 at 10:40 AM, Kenneth Brody
>                 <kenbrody at spamcop.net <mailto:kenbrody at spamcop.net>>
>                 wrote:
>
>                     On 7/2/2014 11:18 AM, scooter6 at gmail.com
>                     <mailto:scooter6 at gmail.com> wrote:
>
>                         A little stumped here
>                         I have a temp file we put records in during
>                         day....and I'd like to
>                         print a
>                         summary 'cover sheet' nightly based on what is
>                         in this file
>
>                         So I have records that will look like this
>                         (all based on client number,
>                         which is first 4 numbers of our 'Account Number')
>
>                         2435-0001        John Smith
>                         2435-0002        Jane Doe
>                         3194-0143        John Consumer
>                         3194-0144         Billy Carter
>                         3194-0145         Ronald Reagan
>                         5498-0254         George Bush
>                         5498-0255         Bill Clinton
>
>                         So, at night, I want to print 3 'CoverSheets'
>                         (one for each unique
>                         client
>                         number: 2435, 3194 & 5498)
>
>                         The CoverSheet report will basically say:
>
>                         Client Number:    2435
>                         Client Name    :   *aa  (this will lookup the
>                         client file using 2435 and
>                         grab the client name)
>                         # of Records    :   2     (this should count
>                         2435-0001 & 2435-0002 and
>                         total unique records)
>                         Starting acct     :  0001  (lowest 'acct' for
>                         2435)
>                         Ending acct      :  0002   (highest 'acct' for
>                         2435)
>
>                     [...]
>
>                     There are several ways I see to do this.  Here is
>                     one method:
>
>                     Sort on the first 4 digits of the client number
>                     (ie: "2345", "3194",
>                     "5498"), with a subtotal break, followed by the
>                     entire 9-digit number.
>                       This way, while you break on the 4-digit client
>                     number, it will also be
>                     sorted by account number.
>
>                     Using @SBRK1, save the first (ie: "lowest")
>                     account number for that
>                     client, using MID.
>
>                     Within @WBRK1, grab the account number, which will
>                     be the "highest"
>                     number for that client.  Then, @RS will be the
>                     number of records for that
>                     account.
>
>                     You now have "# of records" (@RS), "starting acct"
>                     (saved in @SBRK1),
>                     and "ending acct" (the "current" account number,
>                     while in @WBRK1).
>
>                     --
>                     Kenneth Brody
>
>
>         -------------- next part --------------
>         An HTML attachment was scrubbed...
>         URL:
>         http://mailman.celestial.com/pipermail/filepro-list/attachments/20140714/459ce583/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/ad3dc2d2/attachment.html 


More information about the Filepro-list mailing list