RefreshData (Property)

Applies To:

PivotSection object, ChartSection object

Description:

Sets a separate refresh frequency for each Pivot and Chart in a document. When the Query is processed, Reports are populated with data according to their refresh frequencies. There are three methods available for refreshing reports: After Process, OnActivate and Manually. These options are mutually exclusive. An additional option, the RefreshDataNow (Method). This method is only available when Manually is the selected option.

Note:

Refresh options are set on a per-report basis. For example, to refresh ten Pivot reports when they are activated, set the When Section Displayed option for each report.

Action:

Read-Write

Constants:

The BqRefreshData constant group consists of these values:

bqRefreshDataAfterProcess
bqRefreshDataManually
bqRefreshDataOnActivate

Example 1:

In this example, a request is made to manually refresh the Pivot section, after which an immediate refresh to the current section is invoked:

//Manual Refresh of Data
ActiveDocument.Sections["Pivot"].RefreshData=bqRefreshDataManually
ActiveDocument.Sections["Pivot"].RefreshDataNow()

Example 2:

In this example, a request is made to establish an automatic link to the Results section to update the report whenever the query is processed:

//Refresh Data After Processing
ActiveDocument.Sections["Pivot"].RefreshData=bqRefreshDataAfterProcess

Example 3:

In this example, a request is made to refresh when the section is accessed and displayed:

//Refresh Data When Section is Displayed
ActiveDocument.Sections["Pivot"].RefreshData=bqRefreshDataOnActivate