Two for the road, Report from Clerk & Nonstandard Subtotals

[Jeff Harrison]

--- John Esak <john at valar.com> wrote:
[mucho snipped regarding reporting technique]

Hi John.  I have read most of what you described and
it is remarkably similiar to some of the processes
that I have worked with over the years.

Here is what I have done.

#1.  Use dclerk with -xa flag to collect selection
information.  Call this file "tmp1" it is used only as
a place to "sit".

#2.  Create a unique qualifier in the file upon which
you are reporting.  Call this file "transactions" I
have a called routine that I use to do this.

#3.  Create the same qualifier name in another
temporary file called "tmp2".  This will be used to
accumulate subtotal information (similar to the way
you describe)

#3.  Lookup the records that are needed based on the
selection information entered, and post them to a free
record in the unique qualifier in transactions.  Also
post to the subtotal record as appropriate.

#4.  Close the lookups to the temporary files.

#5.  Call dreport off of the "tmp1" file, and select
all records.  @wgt processing for this report will
look up information from you subtotal file as
appropriate to get the totals at the end of the
report.

#6  Remove the temporary qualifiers.

#7  Delete the tmp1 record and exit.

I also log the qualifier names that are created, and I
have cleanup routines that run periodically to clean
up any abandoned temporary qualifiers that may be out
there because of messy exits.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest way to generate code for filePro exports and
imports.


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com