summary sheets from temp file

scooter6 at gmail.com scooter6 at gmail.com
Mon Jul 14 10:57:51 PDT 2014


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 <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>
> wrote:
>
>> On 7/2/2014 11:18 AM, 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/bd416665/attachment.html 


More information about the Filepro-list mailing list