I think all of my reports now create their cursors in the report DE. I don't have any problems with it. One good side effect is when developing the report you can do a preview of the results with little effort.

>I tried that in the early days of VFP5 and ran into problems of VFP losing track of the data fields for no reason. I haven't tried it in VFP6.
>
>>Instead, select into a cursor then close the cursor after the report. Or put your select statement into the init of the report's DE. This way all of the code to create the report is together.
>>
>>>I normally using a SQL to sort out the data and output to a table, eg
>>>
>>> SELE A,B,C From abc.dbf FOR A={01/01/1999} INTO TABLE temp
>>>
>>>,and then run the report.
>>>
>>>I feel that this is not a good way.
>>>
>>>Can anyone can tell me the better way.
>>>
>>>Thank u.