Do a single column sum of values in BIRT

birt
Moses Liao GZ picture Moses Liao GZ · Mar 23, 2013 · Viewed 14.2k times · Source

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

Pablo picture Pablo · Jun 4, 2014

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

Total.sum(dataSetRow["yourRow"])

Related questions

"Unable to locate JAR/zip" error for JDBC connections [BIRT Eclipse, Windows 7, Oracle 11g]

As an FYI, I'm new to this entire stack, so I might be making a basic error. I'm attempting to explore BIRT reporting for a Maximo system that was recently upgraded. To do so, I installed the following: Java 6 & …

Read More
How do I set a parameter to a list of values in a BIRT report?

I have a DataSet with a query like this: select s.name, w.week_ending, w.sales from store s, weekly_sales_summary w where s.id=w.store_id and s.id = ? I would like to modify the query …

Read More
Createprocess error=206; the filename or extension is too long

I know this question has been asked before, but I wasn't able to fix it using solutions from other posts. I'm trying to compile a complex hierarchy of gwt projects using maven. Everything worked fine until I had to add …

Read More