Hello All,
I sometimes seem to have an issue where the report is not fetching properly.
And when the user hits refresh, it will spawn another report execution.
Is there a way to configure a timeout for reports?
I tried canceling, but it looks like it's stuck.
Now, this will slow down the system and cause a gateway restart.
No.
Yup. You should limit the timespans you can pass to your report, or perhaps analyze your DB for query performance (missing indices, in particular).
Yes. If you do not succeed with the limits, you may need to switch to running your report with a script, and script controls to prevent re-execution. Then you will need to use a PDF viewer instead of the Report Viewer.
You may also need more resources for gateway server and DB server.
I can confirm that this is a much better approach to reporting. Generate reports during a low use time (especially very long running ones) through scripting...store them as PDFs into a database, then use @pturmel Blob Server module to present the PDF into a viewer as needed. Of course this only works for pre-generated reports. If you want ad-hoc reporting on the fly...you need to control how much data to show to not take too long or bog down the system.
