You can provide a URL that can be used in external web applications (e.g. portals) to link to a specific Jedox report. Options for this feature are available in the report properties. In Reports, right-click on a report name and click on Properties.
The Properties dialog has two tabs, General and Link. Click on Link.
The Link tab shows the URL for the selected report that can be used in external web applications. The hyperlink can be defined using various options, which are described below:
Mode: here you can specify whether the URL will display the report within the whole project (i.e., with the navigation panel on the left side) or in standalone mode without the navigation panel.
Interface: these options control which parts of the report UI should be shown. Furthermore you can enable sheet zooming for mobile devices and sheet scrolling. Unchecking all options will render the report without any extra UI elements, allowing seamless integration into external web pages. If a specific user has defined use of the ribbon menu instead of the toolbar, the ribbon will only be hidden in standalone links if the "Show menubar" option is not checked.
Credentials: here you can decide if the credentials are included in the URL or not. If credentials are included, the URL will not show a login screen when called, but will instead directly load the linked report using the provided credentials. In standalone mode, in the File menu and in the toolbar in the target window have additional buttons to log out of Jedox:
If the menu bar and the toolbar are not shown, you can provide logout functionality in your application by defining a macro with the __logout() function and attaching it to an object, such as a button.
Attaching Variables to a Report Hyperlink
When using a report hyperlink in an external application, you can extend the hyperlink with settings for Variables in the Jedox Report, allowing you to pass information (e.g. "point of view" settings) from the external environment to the report.
A Variable is addressed in a hyperlink by appending a parameter to the url in the form: <report_link>&var/<variable_name>=<variable_value>
For example, to pass this value 2015 to the Variable @year, the following string needs to be appended: ...&var/year=2015
It is possible to set values for multiple Variables as well. Each further Variable is simply appended with similar syntax.
Furthermore, you can also define multiple values for a single Variable (in reports, the value type of this Variable will then be an array), using the following syntax:
...&var/year[]=2015&var/year[]=2016&var/year[]=2017...
Updated March 27, 2024