How to create a sum variable in ireport?

Question

I am new to JasperReports and iReport designer. Now I have table in that I have a column salary . So I want to display the sum of all employees salary. for that I took a table from pallet created dataset. It displays the table perfectly , in footer I want to display the sum of salary so I created a variable SalSum here is the properties of it,

class: java.math.BigDecimal
calculation: sum
ResetType:Report
Variable Exp: $F{salary}

The problem is , The sum of salary is not displaying and getting the discription as Variable not found:SalSum and The table also displays 3 times in report how to solve this please help me anyone.

score 1 · Accepted Answer · answered Feb 17 '15 at 13:50

1

You can simply drag salary field to the footer area.Then it asks field value or result of aggregation function.You have to choose the second option and from there you select the Sum.That's it

answered Feb 17 '15 at 13:50

Chatz

338
2
10

score 0 · Answer 2 · answered Feb 17 '15 at 07:54

0

the problem is that you might not use the correct tag for the sum,

<textFieldExpression>

you need to use for summing inside ireport.

here is a nice tutorial about how to implement it

answered Feb 17 '15 at 07:54

aurelius

3,946
7
40
73

I am not coding anything , I just doing everything from ireport tool – Raghu Feb 17 '15 at 07:57
I have the tag as `<![CDATA[$V{sumSal}]]>` – Raghu Feb 17 '15 at 07:59
then the problem might be that the sum enters in a second page? have you checked for this? – aurelius Feb 17 '15 at 08:00
second page means What? – Raghu Feb 17 '15 at 08:07
http://stackoverflow.com/questions/17863820/ireport-text-overflows-to-next-detail-band – aurelius Feb 17 '15 at 08:13

How to create a sum variable in ireport?

2 Answers2