Selection criterion question

[GCC Consulting]

Top post,

If you are using - lookup, you need to indicate the index being used with
the - lookup on the command line (-in n indicating the index to use).  Also,
you need -a which is select all records. 

/appl/fp/dreport myfilename -f formatname -v sortseltablename -a -in -y
myautotablename


Richard Kreiss
GCC Consulting
 


> -----Original Message-----
> From: 
> filepro-list-bounces+gccconsulting=comcast.net at lists.celestial
> .com 
> [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.c
elestial.com] On Behalf Of Bruce Easton
> Sent: Wednesday, February 14, 2007 4:49 PM
> To: filepro-list at lists.celestial.com
> Subject: RE: Selection criterion question
> 
> 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.
> 
> 
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>