Jasper Reports

By Sisense

The Jasper Reports plugin provides a pixel-perfect way to export a pivot or table widgets into Excel or PDF files.

The Jasper Reports plugin sends the widget query results and some of the widget metadata to the Jasper library.
You can embed and use the following widget information in your Jasper template.

Note: You should be familiar with Jasper reports and Jaspersoft Studio in order to create Jasper templates.

Installation

  1. Download and unzip the installation package.
  2. Upload the {installationPackageName}/Linux/{pluginName}.tar.gz to the root folder of Droppy (/opt/sisense/storage) or any other folder using SSH.
  3. Connect by SSH to the Linux server.
  4. Navigate to the archive file location and unarchive the file:
    cd {path/to/archive} && tar -zxvf {pluginName}.tar.gz
  5. Navigate into the archive folder:
    cd {pluginName}
  6. Run the installation script:
    chmod +x install_plugin.sh && sh install_plugin.sh
  7. Refresh your dashboard.

Note: External-Plugins pod will be restarted in Kubernetes. Make sure the service is up and running.

Uninstall

  1. Repeat installation steps 1 thru 5 .
    You can skip these stepts if they were completed during installation.
  2. Run the removal script:
    chmod +x remove_plugin.sh && sh remove_plugin.sh

Note: External-Plugins pod will be restarted in Kubernetes. Make sure the service is up and running.

Limitations

  • The plugin is supported only for pivot and table widgets.
  • Formats that are set on the widget level are not presented in the exported file. If you need to apply formats, you can do it on the Jasper template itself.

Jasper Plugin Usage

For more information about using this plugin, see the Jasper Report Manual.

To create a Jasper template with widget information:

  1. To use the widget title or the widget description in your template, add a new parameter.
    To show  the widget title, add a new “WidgetTitle” parameter.
    To show the widget description, add a new “WidgetDescription” parameter.
    You can drag and drop the new  parameters into the template.
  2. The widget query is applied to the report as fields.
    To show the widget results, add a field and change the field title to match the widget field title, as defined in the widget metadata panel.
    For example, you can create in the following widget’s Category and Cost fields in Jasper.
  3. Change the field class to match the type of the field in the cube.
    For example, the Cost field is an integer field.
  4. After the fields are created, drag and drop the fields into the template.
This is a premium Sisense add-on. For pricing details please get in touch with your CSM: Get the Add-On

Version 1.0.1 07-October, 2021

  • Jasper Reports can be exported using the Report Manager. Compatibility with Report Manager version 1.5.4 and up.

Version 1.0.0, 03-Sept, 2021

  • First release
TOP