4 Replies Latest reply on Oct 28, 2014 7:55 PM by Gary Graham-Oracle

    How to prevent the SQL query in a user-defined report from constantly re-executing?

    mariita

      Is it possible to prevent the SQL query in a user-defined report from constantly re-executing? I've created a report based on a six-month old data extract, so there's no need for constant re-execution. Currently the query is re-executing every time I open the report. It's even re-executing when I edit something such as the font, which is super annoying. Also, I've created a master report with 24 child reports, and every time I select a different child report, it seems to execute all 25 SQL queries.