AX1695

GetWebReportDocumentURL function

Generates a URL to a web report within the Axiom file system. This URL can then be referenced in Axiom forms or other web reports, using various features such as Hyperlink components and HREF tags in Formatted Grid components. You can also send the URL to another Axiom user, so that they can open the software directly to that report.

Syntax

GetWebReportDocumentURL("DocumentPath")

Parameter Description

DocumentPath

The document for which you want to return a URL. You can specify this file by entering either of the following:

  • The full path to the file, such as \Axiom\Reports Library\Web\Dashboard.xlsx.
  • The document ID of the file, such as 93. In this case you do not need to place the entry in double quotation marks.

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.

Remarks

  • If your system is deployed in an environment where users work in different system languages, then you should use system folder names in any file paths. For more information, see Using system folder names.

  • GetWebReportDocumentURL is a non-volatile function.

Examples

=GetWebReportDocumentURL("\Axiom\Reports Library\Web\Actuals.xlsx")

This example generates a URL to a web report within the Axiom file system. If used on its own like this, you could copy the URL into a Hyperlink component within an Axiom form or a web report. You could also use the function to supply a URL to the HREF content tag for a Formatted Grid component.

=GetWebReportDocumentURL(8965)

This example is the same as the first example, except in this case a document ID is used to identify the web report.