| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
XL3WebReportLink
Creates a hyperlink that opens an XLCubed Web report and optionally sets web parameters.
Use the Insert Formula > XL3WebReportLink menu or ribbon item to insert the formula using a wizard.
Contents
[hide]Syntax
XL3WebReportLink( Report, [Link Text], [Link Type], [Param1], [Value1],…, [Param13], [Value13] )
Parameters
| Parameter | Description | ||||
|---|---|---|---|---|---|
| Report | A piece of text, indicating the relative path of the report | ||||
| Link Text | The jump text or numeric value that is displayed in the cell. If Link Text is omitted, the cell displays the full web address as the text | ||||
| Link Type | The type of link. Only used from the XLCubed Web Edition
| ||||
| Param1,…, ParamN | The name of the web parameter where the following Value is placed when the link is followed | ||||
| Value,…, ValueN | The value that will passed to the corresponding web parameter |
Example
Create an XLCubed workbook with three XL3WebReportLink statements as below:
Each link has a corresponding XL3WebReportLink:
Test111 =XL3WebReportLink("__userfolders__/IISLTD/nmaudgil/test111.xml", "test111", 1, "closecopies", "true")
Web1 =XL3WebReportLink("__userfolders__/IISLTD/nmaudgil/web1.xml", "Web1", 0, "text", $G$2, "closecopies", "true")
Test2 =XL3WebReportLink("__userfolders__/IISLTD/nmaudgil/test2.xml","test2",1)
Publish this workbook and open in Web Edition:
Click on a link and the report opens. If closecopies is set to true then when you click on a hyperlink to run subsequent reports, you will find the previous report has been closed. This stops the user having many windows open that all require closing manually.
