cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Thanks.

Accepted Solutions (1)

Accepted Solutions (1)

former_member183750
Active Contributor
0 Kudos

Only CR 2008 (12.x) and CR 10.5 (bundles with .NET 2008) is supported in .NET 2008. I do not know if this is the root of the issue (e.g.; you are using CR XI R2 (11.5)), but testing this with CR 2008 will be the best thing to do at this time.

- Ludek

Former Member
0 Kudos

Thank you. We are using the crystal reports objects exposed by SAP crystal reports 11.5 in the C# code to invoke the reports on a back ground thread. These objects are not available and not user friendly in the later versions.

former_member183750
Active Contributor
0 Kudos

Only CR 2008 (12.x) and CR 10.5 (bundles with .NET 2008) is supported in .NET 2008. I do not know if this is the root of the issue (e.g.; you are using CR XI R2 (11.5)), but testing this with CR 2008 will be the best thing to do at this time.

Best I can suggest is that you apply SP 6:

https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe

and keep your fingers crossed.

If SP 6 does not help, you will have to rething your approach; Either don't use cursors, or port the app to the CR SDK for .NET.

- Ludek

Edited by: Ludek Uher on Apr 20, 2011 7:07 AM

Answers (0)