Selection date question

[John Esak]

Don,
I did the exact thing you need to do here for something similar. I use the
login id @id of the user running the report(s) and make a qualifier (from
within processing) for all the files affected. Then I run the reports using
this qualifier for all the temporary data. It works great. If Maggie is
running the file and Ron starts it up as well, I just create "ron" on the
fly and he gets his report also. The next time his qualifier is already made
as well as maggie's. Sam, Bill, Irving, etc. all get qaulifiers made if they
don't exist already. Of course, I clear these temp files with "ddir
filename -k -m username" before I run the reports.  It all works quite well.

If you don't understand the concept or don't know how to creat the
qualifiers on-the-fly, I'll dredge up the process and post it here.

John


> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Don
> Coleman
> Sent: Friday, February 18, 2005 4:08 PM
> To: filePro List
> Subject: Selection date question
>
>
> I have a series of reports (3) different menu selections which function
> as follows:
>
> DPRODIR -K to remove previous selection criteria
> *CLERK to add 19 different selction criteria (2 date fields and 17 YESNO
> fields)
> *REPORT to post data from an archive file to a temporary posting file
> *REPORT to post data from a working file to the same temporary
> posting file
> *REPORT to print the data with data combined from the archive and
> working files
>
> The archive and working files have identical maps.  Their only
> difference is the archive file contains orders processed previously.
> The working file contains only open orders and those orders processed on
> a given day are archived each night.  The data posting and reports
> function as designed.  However, since I am processing from multiple
> files I had to post the date range fields to a control file and could
> not simply use -R to pass the parameter.
> Originally, only one person was running these reports.  Now however,
> more than one person is running them and I am concerned that before one
> process is completed another person will start another process with
> different selection criteria (-V table).  Hence the second person
> running the report could affect the results of person #1 running their
> report depending on where in the process person #1 was.  Does anyone
> have any suggestions for isolating the record being used for one person
> only short of something like this:
>
> Menu selection #1 posts to record #1 in control file
> Menu selection #2 posts to record #2 in control file
> ...
> This method would not work well for two people running the same report
> at the same time.  I would appreciate any better ideas.  Thanks and have
> a good weekend.
>
> Don Coleman
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list