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