Page History

...

select c_username, cast(replace(c_total, '$ ', '') as Decimal(0,2)) as total from app_fd_hr_expense_claim

Image AddedImage Removed
Figure 2: Adding the report definition into Joget UserviewUI's Jasper Reports element

In your iReport Designer, click on the XML tab to copy the definition generated. Paste it into the JasperReports Userview UI element.

At the second tab, select 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 UserviewUI

Materials and Downloads

...