I create an SQL cursor in the PRG. I select the cursor before I do the REPORT command. I do not open any tables in the FRX.

I tried an experiment. I created a FRX with some text in the page header and nothing else. When I try to preview the report, VFP asks for a table. Is there a way to tell VFP not open a table in the report? If I go to the data environment and add any table, the preview works. BTW, I am using VFP 8.0.

I also was able to create the PDF with the test report. So, I guess it is problem with finding the data for the report. Maybe I should move the PRG code to generate the cursor into the FRX. Is that the best way?

Thanks for your help!
Tim

>Report command is allowed in VFP out-of-process server (EXE). It sounds like VFP cannot find the table(s) for report. Where do you open them?
>
>>I created a VCX in VFP and made the class OLE Public. I then created a PRG to CREATEOBJECT the class and call the method to run the report. I ran the PRG from the Command Window. When I did that, VFP froze. An "open" task appeared the task bar. Clicking on "open" would never pull up anything, but when I closed it, VFP was freed up again. The report never ran. After doing some debugging, it looks like the "open" task occurs on the REPORT statement.
>>
>>If a copy the code from the VCX into the PRG and make it a PROCEDURE (no class), it works fine. Am I allowed to run REPORT in an OLE EXE?
>>
>>Thanks for your help!
>>Tim
>>