aspose file tools*
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
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: 7

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: 443
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.
It is sorta covered in the JavaRanch Style Guide.
subject: jasper - ireport - sum