# 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!!!