>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.

---

I suggest you to use the Local View to do the report!

Local View allow to create Calculated field, for most common case, you can best use on View!

The only fail case on Local View is UNION 2 or more SQL to gain rows.

What Barbara said is report data environment has set private datasession!

Then, Has your Form set private datasession?

If you create a Local View or Remote View for it, it will get the data from View directly and
no need to take care private or not!!

At View, you also can add a where condition to select a set of data!

Where.... Master.MainKey = ?PubicPrintKey

Good Luck! ^_~