Jump to content
Changes to the Jaspersoft community edition download ×

How to sum the data of a column in Jasper Report


Recommended Posts

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!


Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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})[/code]

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.

Link to comment
Share on other sites

  • 3 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...