>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.
This usually means that the table you're running against is empty. since you're running against a cursor, make sure the data environment in the report is empty and all of the fields on the report don't reference a specific table (i.e. 'lastname' instead of 'customer.lastname')
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!