BIRT Multiple Tables Aggregation

Hi,

Am developing report in Maximo and am face one issue while creating aggregation on multiple tables.
I have data like below

Total= total1+Total2

MasterItem1
Child1 Value
Child2 Value
Child3 Value

Total1
ParentItem1
Child Value
Child Value
Child Value

Total2

For MasterItem1 have some child data and its value and Total and
same for ParentItem1 , Both are different DataSets(ie.MasterItem1,ParentItem1)
Now i want to show Total out of the Tables .

If any one know solution kindly please help.

Find more posts tagged with

Comments

averma

Hi gautamkulk,
You could save the values of total1 and total2 in scripting variables and use them to calculate total.

gautamkulk

Hi averma,

Thanks for your quick response
Could you please give me example how to do this i didnt work on javascript.

averma

Here is an example:
http://www.birt-exchange.org/org/devshare/designing-birt-reports/1364-agggregating-across-two-tables/