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.

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 0 Existing window (default) 1 New window
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.

Special Parameter Names

You can configure the workbook using parameters with reserved names. You do not add these to the Web Parameters screen, you simply specify them in the formula.

XL3WebReportLink(…[Standard parameters]…, [SpecialParameterName], [Value] )

Parameter	Description
XL3ActiveWorksheetName	The worksheet to display when the report link is opened

See Also

• Formula Reference