Is there a way to prevent a report from automatically running on a dashboard until an interactive filter is applied first?

Jerry Volpe
Tera Contributor

Hello!  I'm wondering if there is a way to prevent a report that is embedded on a dashboard from automatically running on load until a user updates an interactive filter on the same dashboard that controls the report data.

Thank you!

3 REPLIES 3

ChrisSteinke2
ServiceNow Employee
ServiceNow Employee

Hi Jerry. The filters are applied as the loading occurs and to my knowledge, there is no way to delay the loading. There may be some workarounds. The approach to rendering reports is based on what is sometimes called 'lazy loading' where it doesn't actually try to execute/display a report unless it is on screen. So for example, if you have an Interactive Filter at the top of a tab, and a report below out of view, you would get the result you desire as the report wouldn't try to load until you scroll down. Another sneaky approach I think would be to have 2 tabs. The 1st would only contain Interactive Filters, the 2nd would contain the exact same filters, and Reports. If you set the Interactive Filters on the first tab, and navigate to the 2nd, (I think) the values of the Filters would be maintained, and the reports would then only load with the filter applied. 

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0823096 for more information.

ServiceNow Tec2
Mega Sage
This has been resolved by ServiceNow Technical Support. Please refer to KB0827667 for more information.