Selection criterion question

Bruce Easton bruce at stn.com
Wed Feb 14 13:49:03 PST 2007


Bruce Easton wrote Wed 2/14/2007 4:14 PM:

> Tom Carey wrote Wed 2/14/2007 1:42 PM:
>> [..]
>> Is there a way to have the date range selection criteria print on 
>> the report?
>> [..]
> 
> Tom - others have indicated sort/selection processing and some 
> good ideas related to speeding up your reports using lookup dash 
> (which is probably indicated for your application since you are 
> reporting for a recent period of time and as time goes by your 
> report will take longer and longer to run as it reads through all 
> your history of records), but to just satisfy your question, you 
> should have:
> 
> 1. a sort/selection table where you ask the user begin/end dates - 
> declared globally.
> 
> 2. an automatic table that declares the same begin and end date 
> dummy fields (bd and ed - this allows other processing tables to 
> see the values that were set for those fields in the 
> sort/selection table).
> 
> 3. in your current output table, also declare the same date 
> fields.
> 
> 4. use the same dummy fields on your form.
> 
> Bruce

Tom, I should have added a sample of a executable report line 
to make use of the various prc tables:

/appl/fp/dreport myfilename -f myformatname -v mysortseltablename 
 -y myautotablename

To make this work as desired, this indicates that you would need 
to start using this report from a script of some sort or from a 
filepro menu option, and not by running the report from "Request 
Output" on the "filePro Plus Main Menu."

Hmmm - WISHLIST wondering.  Maybe someone already asked for this - 
what if on output forms, you could optionally allow on the 
options screen: 

1. a sort/selection prc table name and 
2. an index letter (for filepro's read records phase)

then these would be used (even over anything on the script line) 
and would thus in many cases eliminate the need for -v and the 
read index letter and would cause such reports to work even from 
a default-install dpromenu.  For that matter why not allow an auto 
and final output prc table to be named on the format as well.  Of 
course it's just another level of hiding something when you may 
be looking for it. :)  Okay, enough wondering.

Bruce

Bruce Easton
STN, Inc.




More information about the Filepro-list mailing list