RefreshAllDataAndFormat

RefreshAllDataAndFormat retrieves the most current data values and formatting from the IBM® Cognos® server and updates those values and formats in the current document.

Syntax

The system must be successfully logged on to the IBM Cognos server.

If you are using IBM Cognos Office with IBM Cognos Analytics data, ensure that the Prompt Update Method property on the Manage Data tab in the IBM Cognos pane is set to Use=Display or Do Not Update to complete the operation. Otherwise, the report cannot be refreshed without user intervention and generates errors.

RefreshAllDataAndFormat()

Example

The following example shows how the RefreshAllDataAndFormat method is used:

Dim bResult as Boolean

bResult = CognosOfficeAutomationObject.Logon
("http://localhost/ibmcognos/bi/v1/disp",
"Administrator", "CognosAdmin", "Production")

'Refresh the data and formatting if we successfully logged on to the
IBM Cognos server.

If bResult Then

  CognosOfficeAutomationObject.RefreshAllDataAndFormat

End If