Get duplicate rows based on one column using BIRT -

i have 1 table in birt report :

           |  name    | amount |            |        |  200   |            |    b     |  100   |            |        |  150   |            |    c     |  80    |            |    c     |  100   | 

i need summarize table in table : name same , add corresponding values.

summarized table :

           |        |  350   |            |    b     |  100   |            |    c     |  180   | 

here a = 200 + 150 , b = 100 , c = 80 + 100

how can summarize table table present in birt report ?

that quite easy. add table report, select same datasource first table (on tab binding)

go tab groups , add group on 'name' column.

you'll see table change. added group header row , group footer row. header have element on grouped (in case name)

now right click next name in amount column. select insert->aggregation.

select function sum, expression should amount, aggregate on should newly created group.

now can see results like:

       |        |  350   |        |        |  200   |        |        |  150   |        |    b     |  100   |        |    b     |  100   |        |    c     |  180   |        |    c     |  100   |        |    c     |   80   | 

if delete detail row table, you'll have result after.

for information: have play this, excersise. move new aggregation group footer, add top border cell, put label total in front if , you'll have this:

       |        |        |        |        |  200   |        |        |  150   |                   ----------        | total    |  350   |        |    b     |        |        |    b     |  100   |                   ----------        | total    |  100   |        |    c     |        |        |    c     |  100   |        |    c     |   80   |                   ----------        | total    |  180   | 

also, don't have select datasource binding, can select first table bindings: select table, open tab biding, select report item , pick first table dropdown. can create complex situations, therefor try work original dataset.