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