summary sheets from temp file

Kenneth Brody kenbrody at spamcop.net
Mon Jul 7 07:40:24 PDT 2014


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


More information about the Filepro-list mailing list