You can define a report to use a data environment class .. and put the code there .. but that will only work for you if every report you need this feature uses the same files. It would also mean that you would have to go through every report to make this change .. and I think that's what you're trying to avoid.

The best suggestion I can make for you in this situation is to NOT use the data environment. Set up your data ahead of time and then call the report.

Sorry there isn't an easy solution for you,
Cathy



>Thanks for that Cathi.
>That will do the job. However, it requires adding code to each reports DE.OpenTables method.
>I was hoping to set a form wide variable in the Report Shell and just before the "Report Form . . ." command add code to the "selected" report DE.OpenTables method. Is this possible?
>i.e. I want to do just what you did only do it from the Report Shell Form.
>Bill