>in the report designer (actually i am in query maker, but it is the same concept), and the client adds a new field to the report. up pops Report Expresson window. client clicks on Expression Builder. would like to see the fields of my query result set displayed in the Fields list box.
>
>any ideas?
>
>thanks - brenda
Breanda,
This one might fit if you like cheating. Normally report designer doesn't show fields if it's a cursor but does show all variables
select * from mytable into cursor myquery
scatter memvar memo blank
modi report myreport
Now fields are in variables list (flexible no alias is used).
Cetin