>>I am using SQL select statement to put all necessary info. into cursor and produce a report. The report works fine, but some how it only produce one person report. In my select statement I specific if the record meet the criteria it will copy all the info into cursor. And I check the bottom of the screen, it say 66 records copy to cursor. Any suggestion why the report only lock to one record??
>>Thanx in Advance
>
>any conditions? (report form myform preview where ??????)
>
>also check report data environment

hi Dave,

I use preview condition: report form myform.frx preview

I didn't put the cursor into my dataenvironment, I thought that cursor only store the information for temperary purpose.
It does print the report on the screen, however I can't go forward to the next record (The print preview on the upper left corner of the report seem to lock to only one record instead of 66) any idea?? I know there are 66 records copy to the cursor, 'cause it show on the screen when it run the program.