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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "jasper - ireport - sum" Watch "jasper - ireport - sum" New topic
Author

jasper - ireport - sum

Gyorgy Pugymer
Greenhorn

Joined: May 22, 2011
Posts: 5
Hi,

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?

Thanks

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jasper - ireport - sum
 
Similar Threads
Sum of the column
Number Trick
iReport sum of field
iReport and using split array elements
acumulative sum with ireport