The problem is that the users can't see the available fields from the report designer. Brenda is using "Query Maker" which creates a cursor of unknown (to the programmer, in advance) name and structure. The problem with the current report writer ever since VFP3 is that you can't see the data tables or fields in the expression builder of the report designer. This was never a problem in any previous version of Fox. The reports are designed at run time.

I have the same problem is that I set up, or at least tweak, my reports at "run-time" and I allow reports to be modified at clients sites depending on user security level. And again the cursors that are created are not visible in the expression builder. A real PITA.

If someone has a workable solution, I'm all ears.

>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.