I need some advice. I have a crystal report in a file and I am using asp.net in a Web Application.
When a user click a button the Crystal Report is exported in another file in the server and then send via email using SMTPServer to other clients.
When two or more users click on the button at about the same time the report is in use for one user then the other user will receive an error message like cannot export crystal report.
To avoid this problem, I did put a try catch method. If the application detects the catch then it process the crystal report again until the report is freed to be process.
It is FIFO and it works but I am not sure it is the best solution.
Is there a better solution, I am afraid that users will wait too long to have there report processed.