In the past when a report was loaded, it automatically runs in order to generate the grid results for it. When trying to create a new report, this is very time-consuming because every time you save a change, the report runs. Some customers found this a cumbersome process that caused unnecessary waiting time for large reports.
ITMS 7.x, 8.x
A new core setting was created: SuppressReportAutorun
When SuppressReportAutorun is enabled and you open any report, the report does not run immediately. To see the results of the report, you must click Refresh.
Each report has the option (as a check box) to disable specific reports for auto-running.
By default SuppressReportAutoRun is set to "0":
If the user has changed SuppressReportAutoRun to "1":
If the user has checked "Auto-Run" for the appropriate report, then after opening this report it will automatically execute the SQL query to show data output.
You can access this "SuppressReportAutoRun" Core Setting by going to SMP Console>Settings>Notification Server>Core Settings. Then search for it and make the change from "0" to "1" to avoid report autorun.
Note: The following SQL script, when run against the database, will turn off autorun for all reports that have previously been run at least one time. Any report that has never been run will not be affected because they are not entered into the table until run the first time.
update ReportExtInfo set AutoRun = 0