Two for the road, Report from Clerk & Nonstandard Subtotals

[John Esak]

Jeff,
The stuff you are suggesting below is really cool.  I'm forwarding it to the
list... . It seems like everyone is always replying just to me and not  the
list.  I must have gottne at least 10 replies about my former  message sent
only to me.  Hope everyone will respond to the list so we all can get some
new information and ideas.

Thanks,

John

P.S. - I'm not clear how you get the free record to "end" ,  and thereby
generate the @wgt processing.



> -----Original Message-----
> From: Jeff Harrison [mailto:jeffaharrison at yahoo.com]
> Sent: Monday, March 14, 2005 5:36 PM
> To: john at valar.com
> Subject: Re: Two for the road, Report from Clerk & Nonstandard Subtotals
>
>
> --- 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