Do a single column sum of values in BIRT

Question

I have a problem here.

I am working on an invoice template using BIRT. I have a table column qty, unit price and amount (unit price * qty). At the table footer, I want to compute the total amount like how excel does its column sum of values. How do I go about doing this?

Answer 1

In the table footer, add a Data. Then, in Data Binding, on Expression:

Total.sum(dataSetRow["yourRow"])

Answer 2

Firstly, Insert a Data element in a grid from a palete where you want the sum. Then right click on that data element in your report and click on 'Change data Column' Select Dataset which have columns 'qty' and 'unit cost' etc. then click on Add Aggregation in this select datatype float and function sum and add expression in which set datarow(name of column) of which you want sum.