Ransome,

I prefer to perform the SQL in the report's OpenTables event of its data environment. Then, under the "Report" menu item, check the "Private Data Session" option. This way the report will close any cursors created in its environment.

HTH
Doug

>Dear all,
>
>In my project I use Selete SQL commands to generate some cursors as the data source of certain report.
>
>Do I need to delete the cursors after I print the report? Will the cursors use up my memory blocks of working areas??
>
>With regards,
>
>Ransome