You might have more success by creating a cursor from a SQL statement and using that for the report. Then you can remove the FOR clause from your REPORT statement.


>I'm trying to create a report that needs to be run for monthly data. However, the PREVIEW screen just flickers, then returns to the form that I have set up to specify the time frame for the report. Suggestions?
>SELECT table1
>SELECT table2
>SET ORDER TO myorder
>REPORT FORM rpt_summ PREVIEW FOR table1.reported#.T. AND MONTH(table1.endingper)=m.month AND YEAR(table1.endingper)=m.year
>
>I've also tried:
>REPORT FORM rpt_summ PREVIEW FOR table1.reported#.T. AND table1.endingper>=m.start AND table1.endingper<=m.finish
>
>I get the same results. If I try to send this report to the printer, and add the prompt, I get the printer prompt, but no report.