General information
Category:
Reports & Report designer
Title:
Can't get the report to use the table created by SQL
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only