>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
James,
With cursors expression builder doesn't show the fields. Either use table or directly enter your fieldnames. You could also create a quick report. ie :
select * from .. into cursor myTemp
create report myReport from (alias()) form
modi report myReport
Cetin