HypExecuteDrillThroughReport

Data source types: Essbase

Description

HypExecuteDrillThroughReport() executes the specified drill-through report. See also HypGetDrillThroughReports.

Syntax

HypExecuteDrillThroughReport(vtSheetName,vtSelectionRange,vtID,vtName,vtURL,vtURLTemplate,vtType)

ByVal vtSheetName As Variant

ByVal vtSelectionRange As Variant

ByVal vtID As Variant

ByVal vtName As Variant

ByVal vtURL As Variant

ByVal vtURLTemplate As Variant

ByVal vtType As Variant

Parameters

vtSheetName: For future use; currently the active sheet is used.

vtSelectionRange: Input parameter; the range of cells in which to execute the drill-through report

vtID: Input parameter; the ID for the execution of the drill-through report. This is returned from the server when you run HypGetDrillThroughReport.

vtName: Input parameter; the name of the drill-through report. This is returned from the server when you run HypGetDrillThroughReport.

vtURL: Input parameter; the URL of the drill-through report. This is returned from the server when you run HypGetDrillThroughReport.

vtURLTemplate: Input parameter; the URL template of the drill-through report. This is returned from the server when you run HypGetDrillThroughReport.

vtType: Input parameter; the type of the drill-through report. This is returned from the server when you run HypGetDrillThroughReport.

Return Value

Returns 0 if successful; otherwise, returns the appropriate error code.

Example

Public Declare Function HypExecuteDrillThroughReport Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByVal vtID As Variant,ByVal vtName As Variant,ByVal vtURL As Variant,ByVal vtURLTemplate As Variant,ByVal vtType As Variant) As Long

Sub HypExecuteDrillThroughReport()
sts = HypExecuteDrillThroughReport("Sheet3", Range("B3"), ids(0), names(0), "", "", "")
End Sub