Ok, if I'm reading what you typed correctly, make sure you have 'Select mycursor' right before the call to the report. In other words
Select mycursor
repo form myreport
>I could browse the cursor But due to the codes in between the other cursor becomes active before the report is called. I could preview the report if I manually enter commant in command window as "select Mycursor" and then I preview the report.
>
>I also tried to open my cursor in Data Environment of My Report by keeping the following code in Int() method of data environment property like "select mycursorname" and in the destroy () USE in Mycursorname. But it also didn't worked.
>
>Previously, I was using DBF files instead of cursor so there was no problem as to which is the active file in use currently.
>
>Is is possible to open cursor through DATA ENVIORNMENT of Report and close it down when the report is exit. If yes, kinldy tell what and where I have to make changes
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place