You refresh a section to retrieve the most current data set from the database to Interactive Reporting document file. The Refresh command can be used in any of the query reporting sections. Once the data set has been refreshed in one section, all sections attached to the Interactive Reporting document file are refreshed as well.
By default, the Refresh Current command (refreshes the current object) in all sections except the Dashboard and the Report sections. In some cases more than one query may be refreshed, if for example, a report references results sets from multiple queries.
In the Dashboard and Report sections, the Refresh All command to refresh all queries in the Interactive Reporting document file is used. Although queries are not visible in to the end-user, they are executed in the order in which they display in the section catalog in the full client version. For example, in an Interactive Reporting document file with three queries, Query1, Query2, and Query3, the queries are executed in that order when the Refresh All command is selected.
If a variable filter has been set for the query by the designer of the <product Interactive Reporting document file, the filter selections must be resolved before the query is refreshed. At that time the user is prompted to select or enter filter values and complete the constraint.
To refresh a section, click 
.