I have a problem with a report, the following reports are failing with the message "REP-501: The specified database cannot be connected.." until we restart the report server.
I think the problem can be that in the AfterReport trigger it creates a couple of files and it can lasts some times (hours), is it possible?
The data are in a table, i.e. the selected rows could be 500K. I think I'll move the creation of the files on the form side, or there is a better way to do it?