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!