File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Other Open Source Projects and the fly likes jasper - ireport - sum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "jasper - ireport - sum" Watch "jasper - ireport - sum" New topic

jasper - ireport - sum

Gyorgy Pugymer

Joined: May 22, 2011
Posts: 10

I need some help about ireport. I have two column. The first column contains the type of a transaction (PURCHASE, TOPUP, STORNO....). The second column contains a number which is the amount of the transaction (1000, 500...). I need the sum of every transaction type (PURCHASE SUM, TOPUP SUM, STORNO SUM....).
So I need as much sums as much different transaction types the column has.

I can get the sum of every transaction, but I can't get the sums separately.

How can I get these sums?


Deepak Pant
Ranch Hand

Joined: Feb 13, 2004
Posts: 446
Without knowing how your report output looks, I can suggest you explore GROUP BY TRANSACTION in the SQL.

In report designer you can have breaks at group level and print group totals.
I agree. Here's the link:
subject: jasper - ireport - sum
It's not a secret anymore!