Hi Nick,
I don't see any problems in the code below.
Check following in your report:
- you are not using table aliases in the fields
- The report isn't using private datasession
- There are no tables/cursors in the reports DE.
>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
--sb--