>>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!
Make sure that your data environment is empty
Bob Sides
SDGS
Vermillion, SD