>Hi Sergey, thanks for answering back. I was trying follow you example that you posted lasttime. I am trying to make the a report work based on this cursor I just created. If I do browse I can that the query is working and correct results appear. Next, in the report I name the detail line field that same as the field in the query (example fname). When I preview the report, it doesn't display any information from the cursor. I have been trying to make this work for 3 days now, but it still doesn't work. I am missing a step some where?
>
>is is the code I typed in:
>
>
>cTable = 'sometable'
>
>
>select fname, totpay, fica, retire_amt, health_ins, retiree_med, ;
>unempins, wrkcompins, total_salary ;
>from payroll_tbl into cursor (cTable) where payroll_tbl.bdate = ldBDate
>
>
>select(cTable)
>report form test preview
>use
>
>Thanks
>Nick Patel
Nick,
Since when a 'select ... into cursor ... ' by default sets current work area to that of cursors you don't need 'select (cName)' there. However that's not the point.
Would you check if your report dataenvironment has some table in it ?
Cetin