As long as you don't need the alias name in the field expressions .. here's a trick you can use:

From the command window, build your cursor. Then enter SCATTER MEMVAR MEMO.

Now go edit your report. This time, when you bring up the expression builder, look in the "variables" list on the right-hand side .. not the table/field list on the left-hand side. You'll see the name of the fields from that cursor!

Cathy


>Hello Group.
>
>I would like to make a report from a cursor. I ran Select * from transdata into cursor temp. The temp cursor showed up on the data session window and I was able to browse it.
>
>I opened up the report designer in manual mode and placed a field textbox on the report. I opened the expression builder and there where no fields from the temp cursor there when I typed in temp.tcname and tried to run the report I got tcname variable not found.
>
>How do I run a report from a cursor. My goal here is to create a report from a SQL Back end without using odbc.
>
>Thanks
>Jim