Announcement

Collapse
No announcement yet.

How to sum fields in JasperSoft IReport

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to sum fields in JasperSoft IReport

    I have created a report using the method outlined here: http://www.scriptcase.net/forum/show...lookin-reports
    However I cant seem to add 2 fields together and then subtract one from the total.

    ($F{Column2} + $F{Column4}) - $F{Column6}

    The above works fine when a number is present (other than 0). However if Column2 is 100 and Column4 is 0, it appends the 0 at the end and makes their total 1000.

    Also is it possible to hide the rows where the sum of the 3 fields equals 0, without displaying this sum?

    Any help would mean a lot.

    Thanks
Working...
X