Two for the road, Report from Clerk & Nonstandard Subtotals

[Jeff Harrison]

--- John Esak <john at valar.com> wrote:

[snip]
> Jeff,
> 
> I misspoke... I meant that I would appreciate it if
> you would NOT send
> (filepro stuff) to my private mailbox. Is there
> really some need to press
> Reply To All
[...snip] 

Well, in my client I have only 2 choices.  Reply to
sender or reply to all.  Do I have the time to go back
and edit the "to:" field?  Yeah, I guess I do.  So I
promise you that I will do this when I remember.  :-)

[snip regarding why run report from same file as
clerk]

> 
> There are lots of reasons. The first and foremost is
> you need "some" record
> somewhere. You have to get it with "some" mechanism
> somehow. Why do it in
> another file than the one you are standing in,
> especially since you would
> have to do just about the same trick wherever you do
> it. Cleaning up the
> excess records, and allowing the reports to be run
> multi-user has to be done
> on some file. If you want to use the clerk method of
> running the report,
> then the requirement is mandatory that you find a
> record on which the report
> can run. I don't care if it is a record in the
> current file you are standing
> in, or a record in some other file. The trick and
> twist is getting that
> record to hit the "end" statement.
> 

[snip] 
> So, do you see the problem yet? The record has to
> "end" eventually... or
> @wgt does not ever get run.
> 
> John
> 

John, to quote you, "No, No, No".  I thought you
understood my approach.  But perhaps you do not.  You
do need a place to stand, but why not in a third file
using the -xa option to rclerk?  Before you exit make
sure to do a delete, and there is nothing much to
clean up.  If you wish you can do a ddir -k on the
file on a weekly basis to truncate the key back to
zero.

My approach coppies the information to a unique
qualifier for each instance that it is run, thus
further satisfying multi-user concerns.

You say:
> If you want to use the clerk method of
> running the report,
> then the requirement is mandatory that you find a
> record on which the report
> can run. 

Using the method I described.  The report runs on the
entire qualified key!  It sits on each record in that
key 1 at a time of course.  @wgt gets run at the
appropriate time - what is to stop it?  

I must not be explaining something sufficiently here. 
As I mentioned I have successfully used this technique
many times over the years.

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!? 
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/