We found the problem. .Net was using Crystal Version 9 and the Reports were written in Version 11. These issues were resolved in version 11. Once we upgraded and rebooted, the open connections went away. There's one caveat to upgrading in Visual Studio, the upgrade changed some other parts...
We tried adding the following code in the 'Page_Unload' method of the web form:
'crReport is the report object
crReport.Close()
crReport.Dispose()
GC.Collect()
And we've tried different variations of closing/disposing of it, but the connections still stay open. It's related to connection...
We built a UI in MS .NET Framework to run Crystal Reports version 11. The Report accesses a SQL Server database using a stored procedure. We've tried using ODBC and OLE to connect to the database. When the user runs the report using the UI and then exits, the connection stays open in SQL...
I have a Version 11 Cross-Tab report that uses a date to group by. The user wants to be able to group by week, month, quarter, and year. All these options are available in Cross-Tab group options. Instead of creating a separate report for each group option, is it possible to just use one...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.