Difference between revisions of "XL3ConnInfo"

(Created page with "This function retrieves information about published reports on the web, in Excel it only exists as a placeholder. Added in Version 9.1. ==Syntax== {{Code|XL3ConnInfo( Co...")
 
(Parameters)
Line 10: Line 10:
 
! Description
 
! Description
 
|-
 
|-
| {{Code|ItemName}}
+
| {{Code|ConnectionId}}
| Text, the name of the report property to retrieve. Valid values are
+
| Number, the number of the connection to retrieve information for
* ReportName
 
* LastPublished
 
*Description
 
* PublishedBy
 
* Path - from version 10.1.35
 
* webserver - from version 10.1.35
 
 
|-
 
|-
 
| {{Code|ItemName}}
 
| {{Code|ItemName}}
 
| Text, the name of the report property to retrieve. Valid values are  
 
| Text, the name of the report property to retrieve. Valid values are  
* ReportName
+
* Server
* LastPublished
+
* Database
*Description
+
* Cube
* PublishedBy
 
* Path - from version 10.1.35
 
* webserver - from version 10.1.35
 
  
 
|}
 
|}

Revision as of 07:29, 14 May 2020

This function retrieves information about published reports on the web, in Excel it only exists as a placeholder. Added in Version 9.1.

Syntax

XL3ConnInfo( ConnectionID, ItemName )

Parameters

Parameter Description
ConnectionId Number, the number of the connection to retrieve information for
ItemName Text, the name of the report property to retrieve. Valid values are
  • Server
  • Database
  • Cube

See Also