Running Multiple Reports

[Robert_Seidman]

I want to shell out from a Visual Foxpro application using runtime and a control file to run 3 different reports in a row.____My problem is getting the program to stop until the first report is finished, before I run the 2nd report, and then to stop after running the 2nd report, before I run the 3rd report.____I know the solutions lies somewhere with the RRUNOUT.dbf, but I can^t figure out how to do it.____Any ideas?____I thank you in advance for your time and attention.____Robert Seidman

[Rick_W_Johnson_(Guest)]

Robert, __This is probably not the most elegant solution, but it is what I do in this situation. I use Visual dBase. I run 7 reports back to back , all about the same length. What I do is put a Pause of 3 seconds in the program when the program goes from one to the next report. This gives the files time to close, but does not start the next report too soon. The three seconds is not even noticed in the actual running. Hope this helps, even though I know there is a more elegant solution.____Rick Johnson

[Robert_Seidman]

I greatly appreciate your reply, but it does not solve the problem. With each report, I would like the user to have the option of choosing to view or print, and then to select the printer. Unless you know how long they will be doing all of this (including the time they spend viewing the report on screen), you do not know when to start the next report. If you start the next report too soon, you will have all sorts of dialogue boxes opening for new reports before the old reports have concluded.____I still think the solution lies with the RRUNOUT.DBF, but I am not quite there yet.____Thanks anyway.____RHS

[kfleming]

If you are using a DBF control file then each report should run in succession.____Kathleen__R&R Support

[Robert_Seidman]

Thank you for your input, but what I want to do , is stop after the first report is run and ask the user if the report ran correctly.__If it has, then it would start the next report.____Once you shell out to R&R, my next Visual Foxpro command runs immediately, rather than waiting for the report to finish.____So before the report finishes, a screen comes up asking whether it printed correctly. This screen should only appear after the report has printed.____Can this be done?____Thank you.____RHS

[Thomas_Freitas_(Guest)]

The problem is in the fox program as it is in Visual dBase. The system will continue on the the next level since it does not know that an outside program is being used.____If you call up another program to run each report, the continuation should not take palce until that report is finished.____Another thing you might trying to do is create a control file for running reports. If you would like to see an example using Visual dBase, you can go to my website, http://www.railsoft.com and click on "Guided Tour-Billing System", then click on reports toward the bottom of the menu.____I don^t know if any of this helps or not, but good luck anyway.

[Rob_Nilsen_(Guest)]

Is there a reason why you don^t use the R&R ActiveX component? If you use that, you could run the report synchronously. It is better than "shelling out" for the apps I^ve done like what you^ve described.