Is it possible to close the DB connections after the page is rendered?
I have a .NET Crystal Reports project that allows me to view reports from within my main program. This works nicely in general, but when the viewer is open it keeps a connection to to database object and further changes to the database are disallowed. What I would like to happen is for the report to take a snapshot of the data and ignore any new changes. It will need to close the active connection to allow modifications to take place. Are there settings that I can change to make the report object open the connection, read the data, then discard the connection? Is there an explicit way to do what I ask after the report source is passed to the viewer?