>>Does anybody know how to replicate
>>SQL syntax, BETWEEN() or IN for
>>example, in generating a report with
>>REPORT FORM ... ? The alternative that
>>I use takes the form of stating the
>>name of the same field as many times
>>as there are variations in its value,
>>and sometimes the total length of the
>>executable line exceeds the limits.
>>
>>Any thought will be appreciated.
>
>why not do the sql and run the report from the cursor you've just built?

...because the FOR clause of the REPORT FORM statement is affected
based on what option or combination of options were chosen from
the form. The data source for REPORT FORM statement is in itself
a result of 7 SQLs. Running another SQL will tie up the operator
to the station until the SQL is done, meaning there will be no
printing. The resulting report takes up to 15 hours to run. Are
you suggesting to establish a shift to watch the screen ? :) But
seriosly, I already found the way. I call a function that accepts
an array of selected values for a field. It then alters a dedicated
field for the records that met the criteria, so all there is left to
do is to REPORT FORM MyReport FOR CheckField = .T. TO PRINT :)