BIRT Exchange Forum: BIRT Multiple Tables Aggregation - BIRT Exchange Forum

Jump to content


 

No Latest Open Poll.

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

BIRT Multiple Tables Aggregation Rate Topic: -----

#1 User is offline   gautamkulk Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 10
  • Joined: 14-September 11


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.
0

#2 User is offline   averma Icon

  • Senior Member
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 713
  • Joined: 08-August 07


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!
0

#3 User is offline   gautamkulk Icon

  • Member
  • PipPip
  • Group: Members
  • Posts: 10
  • Joined: 14-September 11


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.
0

#4 User is offline   averma Icon

  • Senior Member
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 713
  • Joined: 08-August 07


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!
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users