Show TOC

SetShift Locate this document in the navigation structure

This API sets the shift value between the report data range and the row or column axis of the specified report.

Parameter Description
Worksheet as sheet Microsoft Excel worksheet name containing the report. Mandatory.
ReportD as string Identifier of the report. Mandatory.
IsRow as boolean
  • The "true" value returns the shift value for the row axis.
  • The "false" value returns the shift value for the column axis.
Value as integer Shift value.
Note The refresh action is required to update the report.