No able to close connections

[snufse1]

I have an asp application that uses crystal report (pull method). From a drop down list user can select dates and each time a date is selected it runs and displays a crystal report. This works fine. The problem is that I am not able to close the connection to the data base. Every time user selects a new date (within same session) a new connection is being opened and so on. I've tried using CrystalReport.Close and .Dispose but connections stay open even after user has exited the application. Any ideas how to cope with this? Thank you.

 

[Turkbear]

Hi,
Try saving the connection in a session variable and reusing it for each call to the report.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[snufse1]

Crystal reports make the connection as part of the pull method. It is not in the code behind. Any ideas? Thank you.