Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

mariitaOct 28 2014 — edited Oct 28 2014

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.

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 25 2014
Added on Oct 28 2014
4 comments
1,134 views