Two for the road, Report from Clerk & Nonstandard Subtotals

Jean-Pierre A. Radley appl at jpr.com
Mon Mar 14 10:05:18 PST 2005


John Esak propounded (on Mon, Mar 14, 2005 at 03:51:34AM -0500):
| It would be very sloppy to print a  partial report for the current records
| out of the current file and the rest on another partial report  out of the
| archived file, all on different pages. Besides, how would you get the
| total(s)  for the records from both files?  This is a common problem, and
| I'm sure you have all dealt with it lots of times. 

Rather akin to merging records from files of current records and also
from archive files is reporting that gleans data from accounting files
organized to use qualifiers named for the (calendar or fiscal) year.

You might be on a June fiscal year, but your pension plan requires
employee information organized by calendar year.

For reasons unknown to me, Sales Tax reporting to New York State is for
the twelve months from March to February, or for the trimesters ending in
May, August, November and Februrary.

In such cases, John's technique would handily combine data residing in
different qualified key files.

-- 
JP


More information about the Filepro-list mailing list