How to sum the data of a column in Jasper Report

0

Hello! I want to make a Jasper Report that desplays a field and at the end it sums all the numbers from it. The problem is that the column is java.lang.String because it has dashes(-) and numbers. For example I have the column in the picture. I create a variable that sums every number of the column. For every dash it should add a zero. So for the example column the result should be sum=282. I tried the following.

IF(Boolean.valueOf($F{Column}).equals("-") ? $V{Sum} = $V{Sum } + 0 :  $V{Sum}= $V{Sum} + Long.parseLong($F{Column}))

But it gives an error "The left-hand side of an assignement must be a variable"

Does anyone have any ideas on how to do it correctly? Thank you!

 

Attachments: 
jackiehal's picture
Joined: Oct 5 2020 - 7:14am
Last seen: 7 months 1 week ago

1 Answer:

0

Create an Integer variable named "Sum", set it's calculation to "Sum" and set it's expression to 

$F{Column}.equals("-") ? 0 : Integer.parseInt($F{Column})

Basically this is what you are already doing. But, you can instruct Jasper to make the sum for you, so your expression doesn't have to make assignments, it just returns the value of the current record.

gustavofarias's picture
Joined: May 22 2012 - 7:10am
Last seen: 1 hour 28 min ago
Feedback
randomness