SELECT into a dbf
Add to data environment.
Drag fields onto the form.
Take dbf out of the data environment.
USE the frx
REPLACE ALL Expr WITH SUBSTR(Expr, ChopOffTheTableName) FOR ObjType = 8

Check out the frx structure in case there are other object types that you need to cover.

The report has no table names after this and can be run from whatever data you feed it.

>I also gave up using the data enviornment in reports. Just like Cindy I build whatever cursors I need and then refer to them. However, I find that it is a real pain having to manually type in the field names (not being able to use the field picker).
>
>I seems that any cursors not in the data enviornment can not be picked interactively. Does anybody have a better solution?