In a situation like this where the report cursor is dynamic I don't think I'd use the DE. I'd programmatically create the cursor (from selection criteria, whatever), set the result to be the current work area (SELECT), and run the report (REPORT). IF you want to use drag-drop to set up your report, make a table temporarily with the desired structure of the result cursor and then remove it from the DE when you are done.
>>can not establish a dataenvironment for the report. the report is created in code based on client entered parameters (query maker, third party software). do you know how to add a cursor (or table) to the data environment of a report in code? I can not know the correct syntax for this.
>
>Hi Brenda,
>I don't think you can change the DE at runtime (but I could be wrong). Sorry, but maybe someone can jump in here.
>Is that the Query maker from Strategic Edge? If so you have the source code and maybe you could change the way it works.
Eric Shaneson
Cutting Edge Consulting