This is a quick tutorial to show you on how to create a graph using JasperReports iReport. This tutorial uses the HR Expenses Claim App that comes for free in the Enterprise Edition of Joget as the data set.
You will need to have iReport Designer in place to design the report.
Figure 1: Designing your report in iReport Designer.
When designing, remember to point to Joget's database. Create your report in iReport Designer. You may use the SQL used in this example.
| Code Block | ||
|---|---|---|
| ||
select c_username, cast(replace(c_total, '$ ', '') as Decimal(0,2)) as total from app_fd_hr_expense_claim |
Figure 2: Adding the report definition into Joget Userview's Jasper Reports element
In your iReport Designer, click on the XML tab to copy the definition generated. Paste it into the Jasper Reports Userview element in Joget.
At the second tab, choose Default Datasource so that it will read the data set from Joget's current database as well.
Figure 3: Running your Report in the actual Userview
Materials and Downloads
- KB:Expenses Claim App
- KB:iReport Designer report file
- KB:Sample exported PDF file from the Expenses Claim App