Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't get the report to use the table created by SQL
Message
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00253311
Message ID:
00253582
Views:
16
>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 you've defined the report with a private datasession, there's no way the report can see the cursor. Make sure the report is not using a private datasession.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform