I have a page, where reports display based on a prompt value using guided navigation/Conditional navigation
its successfully upgraded from 10G to 11G when we sort on the report title view is disappearing but it appears by clicking on refresh button at bottom of report
.png)
To overcome it you can disable the presentation server Cache but it would cause performance issues so in 11g we have Partial Update option in Advanced Tab of Analysis select Entire Report which would solve the issue.
Partial Update — Use this box to specify whether to update the SQL statement and HTML code only for views or for the entire analysis in response to an event.
- Select either Default or Affected Views to update the SQL statement and HTML code only for the views that have been affected by an event such as drilling or sorting. These settings ensure better performance because the SQL statement and HTML code is generated only for affected views, which prevents the entire analysis from redrawing.
- Select Entire Report to rebuild and redraw the entire analysis.
