summary sheets from temp file
scooter6 at gmail.com
scooter6 at gmail.com
Mon Jul 14 07:51:44 PDT 2014
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/1723ce28/attachment.html
More information about the Filepro-list
mailing list