>Well, the main reason is that when the user is in modify mode he can add a field to the report from report expression builder, just by clicking on field he choses to add.
If the only reason you are trying to do this is to add the fields from the resulting SQL select into the fields listed in the expression builder then here's a workaround ...
SELECT .... FROM ... INTO CURSOR MyCursor
SELECT MyCursor
SCATTER MEMVAR MEMO
MODIFY REPORT ...
By doing the SCATTER MEMVAR MEMO, the fields from the cursor end up as memory variables and will show up in the "Variables" list box in the expression builder (as opposed to the "fields" list box). But it lets the user see the fields so they can select them from the expression builder.
Cathy