>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.
I have two advices:
1. Pull data in temporary cursor using SELECT-SQL and use plain REPORT FORM command.
2. If length of compiled command exceed limits you can split command line using macros:
cComline1="....."
cComline2="....."
.....
REPORT FORM &cComline1 &cComline2 ....
Edward Pikman
Independent Consultant