How to customize Reporting in Soffid

Using iReport

Steps

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

1. Download the iReport classes from Soffid.

1.1. Open the Reports screen.

Main Menu > Administration > Monitoring and reporting > Reports

1.2. Click on the "Reports definitions" tab.

1.3. Click on the hamburger icon.

1.4. Click on the "Download iReport componet" option and save in your computer the file.

1.5. Once you have saved the file, you need to customize the hibernate.cfg.xml file to point your development database.

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

2. Download the iReport designer from  sourceforge.

2.1. Execute iReport.

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

2.2. Add iReport addon jar, previously downloaded on step 1.4

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

 

image-1647254436975.png

5. Design your report, using the hibernate connector or open an existing one.

The data model documentation, including E-R diagrams is here.

6. Upload your report to Soffid Console.

7. 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. 

Steps

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

1. Download the Report designer from the Soffid download page.

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

2. Open the custom Jaspersoft report designer.

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

3. Add a new Soffid Data Adapter

image-1651765772922.png

4. Design your report or open an existing one.

The data model documentation, including E-R diagrams is here.

5. Upload your report to Soffid Console.

6. Execute or schedule it!!!