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?
posted 5 years ago
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.