Report in a Separate Window

Question:
In a FoxPro 6.0 application, I want to be able to push a button anddisplay a report on the screen. This report should be displayed in a new window, separate from the one containing the button.

Answer:
The REPORT command has a WINDOW clause that will do what you need. You can create a window using DEFINE WINDOW RWIND …. , and then REPORT FORM XYZ WINDOW RWIND and the report will appear in the separate window.

A simpler way is to create a form, run the form with the NOSHOW clause, and then execute the REPORT command:

1. Create a form called RSHOW by executing the following command from the Command Window:

   CREATE FORM RSHOW

2. Don’t do anything to the form. Just save it.
3. Run the form without showing it by executing the following command from the Command Window:

   DO FORM RSHOW NOSHOW NAME RSHOW

4. Run the report in the form by executing the following command from the Command Window:

   REPORT FORM MyReport WINDOW (RSHOW.Name) PREVIEW NOWAIT

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.