SELECT .... FROM... WHERE...ORDER BY....
INTO CURSOR ....
REPORT FORM "Applications:Microsoft Visual FoxPro:SDS Tracking:reports:ADVISING.FRX" NOCONSOLE PREVIEW

I have the above query and the report would show up and disappear right away. If I try to run it with the last line that reads "REPORT FROM ...", then the query result would display. But I want the results to show up in my report (designed by the wizard).

Also, is there a quick and easy way to refresh(make them blank) all the controls from a form. I tried thisform.refresh and it did not work.

Thanks in advance!