How to sum all values in a column in Jaspersoft iReport Designer?

It is quite easy to solve your task. You should create and use a new variable for summing values of the “Doctor Payment” column. In your case the variable can be declared like this: <variable name=”total” class=”java.lang.Integer” calculation=”Sum”> <variableExpression><![CDATA[$F{payment}]]></variableExpression> </variable> the Calculation type is Sum; the Reset type is Report; the Variable expression is $F{payment}, … Read more