Eclipse Community Forums: BIRT » Aggregation in BIRT -need to sum aggrevated values (total1+total2) coming from two different Dataset

Home » Archived » BIRT » Aggregation in BIRT -need to sum aggrevated values (total1+total2) coming from two different Dataset(Aggregation in BIRT - need to sum aggrevated values)

Show: Today's Messages :: Show Polls :: Message Navigator

Aggregation in BIRT -need to sum aggrevated values (total1+total2) coming from two different Dataset [message #1723923]

Fri, 19 February 2016 05:31

fathima rizwana

Messages: 4
Registered: September 2015

Junior Member

Hi Everyone,

I need a very Urgent help in Birt 232 where I have to sum two aggregated values calculated on two different datasets.

I have a attached the report viewer and rptdesign for your reference.
I have created a table with maindataset binding. I have two other datasets displaying items and labour lines.
Inside this main table , in the detail row I have created three tables each one displaying three datasets data. First table displaying maindataset query , second displaying item lines , third displaying labor lines.
In the second I have put aggregation of total item cost (4125.2)and one more aggregation on total labor cost(450).
Now my question is How do i ADD this two aggregated values which comes from two different datasets??

I have highlighted in yellow these two values in the attached report viewer which needs to be added and displayed at the bottom as 4575.25.
my report layout looks like below:
MainDataSet #1 - WarrantyNo123
header details
DataSet #2 - item lines details
col1 | col 2 | Total
x | x | 10
x | x | 10
total item line cost - 20
DataSet #3 - labor line details
col1 | col 2 | Total
x | x | 30
x | x | 40
total labor line cost - 70
total claim Amt - 70+20 =90
MainDataSet #2 - WarrantyNo234
header details
DataSet #2 - item lines details
col1 | col 2 | Total
x | x | 40
x | x | 10
total item line cost - 50
DataSet #3 - labor line details
col1 | col 2 | Total
x | x | 40
x | x | 40
total labor line cost - 80
total claim Amt - 50+80 =130
---------------------------------------------------------------------------------------
Grand Total Claim Amt - 90+130 = 220
--------------------------------------------------------------------------------------------
keeps repeating for multiple warrantynos
and at last prints for grand total.

CAn anyone help?? Thanks