Summary
By default, Yellowfin reports will run automatically when they are first loaded. This article covers how to disable that behaviour using the Autorun Report on Load setting in the Report Builder, as well as how to bulk update the setting across multiple reports using SQL queries against the configuration database.
Note that you must have at least one filter added to your report before the Filter Options panel will appear.
Disabling Autorun Report on Load in the Report Builder
1. Open Filter Options
In the Report Builder, navigate to the Data page and open Filter Options.
2. Open Filter Display & Actions
Click on Filter Display & Actions if not already selected.
3. Toggle the Setting
In the Actions menu, locate the Autorun Report on Load toggle and switch it off. This will prevent the report from running automatically when it is first opened.
Bulk Updating Reports via SQL
If you need to update this setting across many reports at once, you can use the SQL queries below against the Yellowfin configuration database.
Please note the usual caveats when editing the configuration database directly. Yellowfin is not responsible for any issues that arise from modifications to the database. Always create a backup before making any changes.
Check the Current Status
This query lists the current status of the Autorun Report on Load setting for each report:
SELECT h.ReportName, f.ReportId, f.EntityCode, f.FormatTypeCode, f.FormatCode FROM ReportFormat f INNER JOIN ReportHeader h ON (f.ReportId = h.ReportId) WHERE f.EntityCode = 'TITLE' AND f.FormatTypeCode = 'WAITFORPROMPT' AND h.ReportStatusCode = 'OPEN'
Bulk Update Existing Records
This query updates the setting for all reports that already have a WAITFORPROMPT format record. Set FormatCode to TRUE or FALSE depending on whether you want to enable or disable the setting.
UPDATE ReportFormat
SET FormatCode = 'TRUE'
WHERE EntityCode = 'TITLE'
AND FormatTypeCode = 'WAITFORPROMPT'
AND ReportId IN (
SELECT ReportId FROM ReportHeader
WHERE ReportStatusCode = 'OPEN'
)
Insert Missing Records and Enable
This query inserts a WAITFORPROMPT record set to TRUE for any report that does not already have one. Once this has been run, the UPDATE statement above can be used to toggle the state back to FALSE if required.
INSERT INTO ReportFormat
(ReportId, EntityCode, EntityId, FormatTypeCode, FormatCode, FormatValue, FieldId, ChartId, SeriesId)
SELECT
h.ReportId, 'TITLE', 0, 'WAITFORPROMPT', 'TRUE', 0, 0, 0, 0
FROM ReportHeader h
LEFT OUTER JOIN ReportFormat f
ON (h.ReportId = f.ReportId
AND f.EntityCode = 'TITLE'
AND f.FormatTypeCode = 'WAITFORPROMPT')
WHERE h.ReportStatusCode = 'OPEN'
AND f.FormatCode IS NULL
If you are still encountering problems or have questions, contact Support with a new ticket or send us an email.