Selection criterion question

[Kenneth Brody]

Quoting Tom Carey (Wed, 14 Feb 2007 12:41:46 -0600):
[...]
> Is there a way to have the date range selection criteria print on the
> report?
>
> At present the user says no to the select all records question and then
> enters the date selection range in the GE and LE format to select a
> weeks or months data to create a total.
>
> At present I can't think of a way to get that info from the selection
> range to the report.
[...]

There's the "lookup dash method" in sort/select processing.

Basically, you ask (in processing) for the start and end dates,
and save those in global variables.  You then use "lookup dash"
to the first date, and then continue to SELECT records as long
as the date is in that range.  Finally, when you get past the
end of the range, you "lookup dash" to the highest possible date
in the file, effectively ending the sort/select phase.

Since the start and end dates were generated within processing,
you have access to these values for placement on the output.

(Note that you must be running *report on the index being used
by the lookup.)

I'm sure that there are samples of this in the list archives,
and/or that someone will post a complete example shortly, should
you need further help.

Finally, shameless plug time...

Laura has a callable library routine to handle asking for dates
(either a single date, or a date range) for sale for only $10,
including source code:

    http://www.hvcomputer.com/shopping/orderform.shtml#fplib1


--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com