HypGetDrillThroughReports
Data provider types: Oracle Essbase
Description
HypGetDrillThroughReports() retrieves a list of drill-through reports. See also HypExecuteDrillThroughReport.
Syntax
HypGetDrillThroughReports(vtSheetName, vtSelectionRange, vtIDs, vtNames, vtURLs, vtURLTemplates, vtTypes)
ByVal vtSheetName As Variant
ByVal vtSelectionRange As Variant
ByVal vtIDs As Variant
ByVal vtNames As Variant
ByVal vtURLs As Variant
ByVal vtURLTemplates As Variant
ByVal vtTypes As Variant
Parameters
vtSheetName: The name of worksheet on which to run the function. If vtSheetName is Null
or Empty
, the active worksheet is used.
vtSelectionRange: The range of cells that contain the drill-through reports to retrieve
vtIDs: Output variable; the array of the IDs returned from the server
vtNames: Output variable; the array of the names returned from the server
vtURLs: Output variable; the array of the URLs returned from the server
vtURLTemplates: Output variable; the array of the URL templates returned from the server
vtTypes: Output variable; the array of the types returned from the server
Return Value
Returns 0 if successful; otherwise, returns the appropriate error code.
Example
Public Declare Function HypGetDrillThroughReports Lib "HsAddin" (ByVal vtSheetName As Variant,ByVal vtSelectionRange As Variant,ByRef vtIDs As Variant,ByRef vtNames As Variant,ByRef vtURLs As Variant,ByRef vtURLTemplates As Variant,ByRef vtTypes As Variant) As Long
Sub Example_HypGetDrillThroughReports()
sts = HypGetDrillThroughReports("Sheet3", Range("B3"), ids, names, urls, urltemplates, types)
End Sub