summary sheets from temp file
scooter6 at gmail.com
scooter6 at gmail.com
Mon Jul 14 11:47:42 PDT 2014
Should my output format be 'subtotaled' on BOTH client number AND full
account number?
Currently it's only subtotaled once in Sort options....
On Mon, Jul 14, 2014 at 2:43 PM, Bruce Easton <bruce at stn.com> wrote:
> 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
> _______________________________________________
> Filepro-list mailing list
> 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/b7669811/attachment.html
More information about the Filepro-list
mailing list