Jump to content

BIRT Developer Center
Download


Photo
- - - - -

BIRT Multiple Tables Aggregation


  • Please log in to reply
3 replies to this topic

#1 gautamkulk

gautamkulk

    Member

  • Members
  • PipPip
  • 10 posts

Posted 29 March 2012 - 01:48 AM

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.

#2 averma

averma

    Senior Member

  • Members
  • 713 posts

Posted 29 March 2012 - 05:07 PM

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

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!


#3 gautamkulk

gautamkulk

    Member

  • Members
  • PipPip
  • 10 posts

Posted 29 March 2012 - 07:44 PM

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

#4 averma

averma

    Senior Member

  • Members
  • 713 posts

Posted 30 March 2012 - 10:18 AM

Here is an example: http://www.birt-exch...oss-two-tables/

Ashwini

Follow me on Twitter
Read my Blog BIRT Rocks!