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