>I want to know why when I open tables they do not appear in the dataenvironment of the report. Without these the report is very difficult to use. There are lot o relations that are easier to establish with a program than through this tool. Is there anything I could do to fix this problem.!

You can issue a thing like this in your routine before running the report:

if not inlist(justext(sys(16,1)),"EXE","APP")
modify report [report name here]
endif
Report Form ...

This way you already have all the SQL and other stuff done, and you can edit your report in exactly the same environment as the one where it will run. In the final .exe or .app the editor will not be invoked.