Skip to Content
Former Member
Apr 15, 2011 at 10:31 PM

Closing the ref cursor after dispaying the crystal report from ASP.NET


Dear All,

I am using crystal reports version 11.5 and Oralce 10g , VS.NET 2008. I am using procedure wiht ref cursor as a data source for my report. With in my report I use table as data storage. I open a cursor for selection from this table.

With above I have couple of reports using the same table as data storage. I am having a problem when the user tries run a report while the other is open. The first crystal report not releasing the ref cursor and underlying table.

It works as long as I close and reopen another. But not working while the another report is in view mode.

I appreciate any suggestions.