>Let me first start out by saying we don't use the data environment in the report designer. In our application we let the user modify the report inside the applicaton with a modify button that issues a modify report statement. Now since we don't use the data environment we don't get the list of fields in the Expression's Expression Builder. Is there a way to change that so we can get the list of fields
with out putting the tables in the report's data environment?
Use code as follows:
SELECT MyTable
SCATTER MEMVAR MEMO
MODIFY REPORT
The variables won't appear in the left side of the expression builder window where all the table fields normally do ... but they will appear in the right side of the expression builder window in the VARIABLE section. You just have to teach your users how this "work-around" works!!
Cathy