>I have a form containing several controls that is working. I established a Data Environment containing three tables. My SQL statement uses the three files to create an output table. Calling the report from a command button results in errors that the output table can't be found. I try to put it in the report Data Environment, but that doesn't help. I have tried various combinations of code, but nothing seems to work. Where should I mention the table other than the output of the SQL? I have spent 20 hours of trial and error and haven't found the answer yet.
If the resulting cursor from the SQL exists, all you need - SELECT myCursor and run the report. For such reports I do not include the alias to the fields in the report. Maybe you can post the code from your Print button here?
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison