Hello All,
I am writing an application with Visual FoxPro 5.0 on NT and using Crystal Reports 6.0 as a report generator for this application. The appropriate ODBC connections are set up for Crystal Reports to read the VFP data sources. I am using an OCX to run the report. I am looking for a way to 'wait for process to end' before continuing with the rest of the code.
The process is as follows:
1. check a checkbox on a form to select a report and press OK button
2. OK button then calls a method which creates a temporary table based on the report selection, which is to be used as the datasource for the report. When the queries are completed and the table is built, the following code is run to generate the report:
ThisForm.Olecontrol1.ReportFileName = "g:\rpts\mkdetail.rpt"
ThisForm.Olecontrol1.LogonServer ("pdsodbc.dll", "ASSETREVRPT", "", "", "")
ThisForm.Olecontrol1.LogonServer ("pdsodbc.dll", "ASSETREV", "", "", "")
ThisForm.Olecontrol1.Action = 1
3. The rest of the code in the method, following the above code, is to delete the temp tables just created for the report.
I am requesting a way to wait for the report to be closed before the code is processed to delete the temp tables. Maybe a property of the OCX, or a system command?? Any ideas??