__xls-2-image-unique-image-unique

__XLS

<h4>Installation</h4>
<ol>
<li>Download and unzip the installation package.</li>
<li>Upload the {installationPackageName}/Linux/{pluginName}.tar.gz to the root folder of Droppy (/opt/sisense/storage) or any other folder using SSH.</li>
<li>Connect by SSH to the Linux server.</li>
<li>Navigate to the archive file location and unarchive the file:
<pre>cd {path/to/archive} &amp;&amp; tar -zxvf {pluginName}.tar.gz</pre>
</li>
<li>Navigate into the archive folder:
<pre>cd {pluginName}</pre>
</li>
<li>Run the installation script:
<pre>chmod +x install_plugin.sh &amp;&amp; sh install_plugin.sh</pre>
</li>
<li>Refresh your dashboard.</li>
</ol>
<p><strong>Note</strong>: External-Plugins pod will be restarted in Kubernetes. Make sure the service is up and running.</p>
<h4>Uninstall</h4>
<ol>
<li>Repeat installation steps 1 thru 5 .<br />
You can skip these stepts if they were completed during installation.</li>
<li>Run the removal script:
<pre>chmod +x remove_plugin.sh &amp;&amp; sh remove_plugin.sh</pre>
</li>
</ol>
<p><strong>Note</strong>: External-Plugins pod will be restarted in Kubernetes. Make sure the service is up and running.</p>
<h4>Limitations</h4>
<ul>
<li>The plugin is supported only for pivot and table widgets.</li>
<li>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.</li>
</ul>
<h4>Jasper Plugin Usage</h4>
<p>For more information about using this plugin, see the <a href="https://data.sisense.com/Marketplace/jasperReports/public/Jasper+Report+Manual+v2.1.0.pdf">Jasper Report Manual.</a></p>
<p><strong>To create a Jasper template with widget information:</strong></p>
<ol>
<li>To use the widget title or the widget description in your template, add a new parameter.<br />
To show  the widget title, add a new &#8220;WidgetTitle&#8221; parameter.<br />
To show the widget description, add a new &#8220;WidgetDescription&#8221; parameter.<br />
You can drag and drop the new  parameters into the template.<br />
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jasper-parameter-370x190.png" alt="" width="370" height="190" /></li>
<li>The widget query is applied to the report as fields.<br />
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.<br />
For example, you can create in the following widget&#8217;s Category and Cost fields in Jasper.<br />
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jasper-field-370x226.png" alt="" width="370" height="226" /></li>
<li>Change the field class to match the type of the field in the cube.<br />
For example, the Cost field is an integer field.<br />
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jasper-field-class-370x220.png" alt="" width="370" height="220" /></li>
<li>After the fields are created, drag and drop the fields into the template.<br />
<img loading="lazy" decoding="async" class="img-polaroid alignnone" src="https://cdn.sisense.com/wp-content/uploads/jasper-template-370x190.png" alt="" width="370" height="190" /></li>
</ol>


jasper-addon-v2-1-image-unique

Jasper-Addon-V2 (1)

BloX

Export Enhancements

Pivot

Table

excel

export

pivot

pixel perfect

table

<p>The Jasper Reports plugin provides a pixel-perfect way to export a pivot or table widgets into Excel or PDF files.</p>
<p>The Jasper Reports plugin sends the widget query results and some of the widget metadata to the Jasper library.<br />
You can embed and use the following widget information in your Jasper template.</p>
<p><strong>Note</strong>: You should be familiar with Jasper reports and Jaspersoft Studio in order to create Jasper templates.</p>


Get the Add-on

Leave Feedback