summary sheets from temp file

scooter6 at gmail.com scooter6 at gmail.com
Mon Jul 14 10:58:36 PDT 2014


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 <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 <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/459ce583/attachment.html 


More information about the Filepro-list mailing list