# How to customize Reporting in Soffid



# Using iReport

## Steps

Once you have installed the Reporting add-on you must follow the following steps:

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.</span> Download the iReport classes from Soffid.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.1.</span> Open the Reports screen.

`Main Menu > Administration > Monitoring and reporting > Reports`

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.2.</span> Click on the "Reports definitions" tab.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.3.</span> Click on the hamburger icon.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.4.</span> Click on the "Download iReport componet" option and save in your computer the file.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.5.</span> Once you have saved the file, you need to customize the **hibernate.cfg.xml** file to point your development database.

<table border="0" id="bkmrk-%C2%A0-%3Cproperty-name%3D%22co" style="width: 100%; border-collapse: collapse; border-style: hidden;"><tbody><tr><td style="width: 5.80247%; border-style: hidden;"> </td><td style="width: 94.1975%;">```XML
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://172.20.0.2:3306/soffid</property>
<property name="connection.username">YOUR_USER</property>
<property name="connection.password">YOUR_PASS</property>
```

</td></tr></tbody></table>

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">2.</span> Download the **iReport** designer from [sourceforge](http://sourceforge.net/projects/ireport/files/iReport/).

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">2.1.</span> Execute iReport.

- - Be in mind, if you are using the proper Java version.

To execute iReport in Linux: `./ireport --jdkhome /usr/lib/jvm/jdk1.7.0_80/`

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">2.2.</span> Add iReport addon jar, previously downloaded on step 1.4

Go to: `Tools > Options > Classpath` and then: **Add JAR**

[![image-1647254436975.png](https://bookstack.soffid.com/uploads/images/gallery/2022-03/scaled-1680-/image-1647254436975.png)](https://bookstack.soffid.com/uploads/images/gallery/2022-03/image-1647254436975.png)

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">5.</span> Design your report, using the **hibernate connector** or open an existing one.

<p class="callout info">The data model documentation, including [E-R diagrams is here](http://www.soffid.org/doc/console/latest/uml/entities.html).</p>

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">6.</span> Upload your report to Soffid Console.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">7.</span> Execute or schedule it!!!

# Using JasperReports

## Introduction

Soffid provides an addon to execute a custom Jaspersoft report designer. Configure a new Soffid data adapter will be mandatory with the proper data to connect to Soffid console, it will not be necessary to configure the database connection.

Then you can use your custom Jasper report designer, it will be in charge to make REST requests to the Soffid console, and Soffid console will make the requests to the database.

<span style="color: #222222; font-size: 2.8275em; font-weight: 400;">Steps</span>

Once you have installed the Reporting add-on you must follow the following steps:

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">1.</span> Download the Report designer from the Soffid download page.

You could donwload in the following link [http://www.soffid.com/download/enterprise/](http://www.soffid.com/download/enterprise/) if you have Soffid user with authorization, or in the following [http://download.soffid.com/download/](http://download.soffid.com/download/) by registering.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">2.</span> Open the custom Jaspersoft report designer.

```shell
root@soffid:/home/user/Descargas/jaspersoftstudio# ./Jaspersoft\ Studio
```

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">3.</span> Add a new Soffid Data Adapter

- **Name**: data adapter name.
- **Soffid console URL**: your Soffid console URL.
- **User Name**: user to connect to Soffid Console.
- **Password**: password to connect with the user to Soffid Console.

[![image-1651765772922.png](https://bookstack.soffid.com/uploads/images/gallery/2022-05/scaled-1680-/image-1651765772922.png)](https://bookstack.soffid.com/uploads/images/gallery/2022-05/image-1651765772922.png)

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">4.</span> Design your report or open an existing one.

<p class="callout info">The data model documentation, including [E-R diagrams is here](http://www.soffid.org/doc/console/latest/uml/entities.html).</p>

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">5.</span> Upload your report to Soffid Console.

<span style="color: #a6d100; font-weight: bold; font-size: 18px;">6.</span> Execute or schedule it!!!