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...")
 
(+ categories)
 
(3 intermediate revisions by one other user not shown)
Line 1: Line 1:
This function retrieves information about published reports on the web, in Excel it only exists as a placeholder. Added in [[Version 9.1]].
+
This function retrieves information about published reports on the web, in Excel it only exists as a placeholder. Added in Version 10.0.35
  
 
==Syntax==
 
==Syntax==
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
 
  
 
|}
 
|}
Line 34: Line 25:
  
 
[[Category:Formulae]]
 
[[Category:Formulae]]
 +
[[Category:Report Management Formulae]]
 +
[[Category:Report Management]]

Latest revision as of 10:20, 21 October 2022

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

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