Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jasper - ireport - sum

 
Gyorgy Pugymer
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 446
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic