>After searching the help file, I am unable to find how to add a query as my data environment for a report. The data environment will only allow me to add tables.
>Any thoughts?

Then don't add anything, just use the report's dataenvironment.init and put whatever code you need into it. Any private or public variables defined in the code which runs the report are visible - haven't tried locals, though, but some people here did and they should work as well. You can put any code you like, except you can't have any local procedures or functions - but then you can instantiate any class you like and call its methods. The possibilities are unlimited.