Elements of dimensions that contain child elements, are displayed by default as hyperlinks.
NOTE. The Reports tool displays hyperlinks as a simple text by default.
Example of table with hyperlinks:
NOTE. On opening the hyperlink the action that is different from the default action can be set up.
To show or hide hyperlinks, deselect or select the Hyperlinks as Plain Text checkbox on the Parameters side panel tab.
By default, clicking the hyperlink leads to elements of the child level of hierarchy. On opening the hyperlink the following actions can also be set up:
Changing selection.
Moving to another sheet or another object.
Selecting cells.
Opening link/file/repository object.
NOTE. Various detailing types can be set for dimension and for all its levels.
To select the action, which will happen on opening the hyperlink:
Go to the Detailing side panel tab.
To enable settings on the Detailing tab, select the checkbox in the tab header.
Select the report sheet, to which settings are applied, in the Apply to Sheet drop-down list in the express report. Select the report slice, to which settings are applied, in the Apply to Slice drop-down list on the dashboard or in the regular report.
To change dimension selection on moving to the other report sheet or on opening a document, execute the following operations:
In the Dimension drop-down list select the dimension, in which selection is changed on opening a hyperlink. The list contains all dimensions, on which data table is based.
In the Method of Selection Change drop-down list select one of the selection change options in the selected dimension:
Not Selected. Dimension selection does not change.
Replacement. All available selection in the dimension is cleared, and only the element, which hyperlink is clicked, remains selected.
Inversion. The dimension selection of the element, which hyperlink was clicked, will be replaced with the opposite one.
Addition. The element, which hyperlink is clicked, is selected in the dimension, unless this element has been previously selected.
In the Index to Search Elements By drop-down list select index of the dimension selected in the Dimension box. This index is used to search for the element, which hyperlink was clicked. By default, the Undefined option is selected, index is selected automatically.
In the Search Attribute in the Index drop-down list select the dimension attribute, for which detailing is set up. Values of this attribute are used to find attribute value for the index selected in the Index to Search Elements By list. By default, the Undefined option is selected, attribute is selected automatically.
Select the Run checkbox to enable to select the action, which will be executed on opening the hyperlink of dimension element:
Open File. On clicking the hyperlink the selected file opens. It is available to use substitutions in the text.
NOTE. The action is available only in the desktop application.
Open Link. Clicking the hyperlink opens the specified URL. It is available to use substitutions in the text.
NOTE. On working in the web application the link must begin with "http://" or "https://".
Go to Sheet. On clicking the hyperlink the selected sheet opens. The action is absent in the dashboard.
Show Cell Range. On clicking the hyperlink the selected cells are highlighted. The following options of determining a cell range are available:
To describe rectangular area, specify addresses of upper left and lower right cells via the ":" character. For example, "A1:B3".
To describe one cell, enter its address. For example, "C3".
To describe combined area, specify several areas using ";" character to separate them. For example, "A1:B3;C3".
Show Object. On clicking the hyperlink moving to selected report object is executed. The action is available only in the desktop application.
Open Repository Object. On clicking the hyperlink the selected repository object opens. It is available to specify repository object with parameters.
Execute Function. The function is executed on clicking the hyperlink. The operation is available only in regular reports.
Set function parameters:
Unit. Select a development environment unit or form, connected to regular report.
Function. Specify name of the procedure or function that must be started in the desktop application on hyperlink click.
JS-Function. Specify name of the JS-function that must be started in the web application on hyperlink click. This may be a system and a custom JS-function.
To be used, the custom JS-function must be connected to report. For details about how to do it, see the Connecting Custom JS-Function to Report section.
NOTE. It is allowed to specify only procedure or function name or JS-function name. In this case the hyperlink opens only in the desktop or only in the web application.
After executing the example, the operation which is executed on following the hyperlink, will be set up.
See also:
To display the Parameters tab
button and select the item containing the dimension name or its level.