How to create aggregation to Sum the duration?

I have to create aggregation to calculate the sum for the duration?

Example for Duration:

05:56:123
12:05:526

Note : Returning duration as string from the data set query.

Find more posts tagged with

Comments

CBR

First i would suggest that you use a new Data element in your table. You can calculate the value of this data element using a formula similar to Birt.DurationHours(row["start"], row["end"]) (just a example don't know the correct name of this function...only sure about the existence of such)

This data element calculates the duration for each detail row of your table. Finally you re able to do some aggregation on it (using a data element inside a table results in a data binding beeing created...so it's like that row exists in your dataset the table is bound to)