passing data beween nested tables

hi,

i have a really important problem to solve.

i have desgined a nested table in a table.
the outer table is bound to a data set and the nested table is bound to a scripted data set.
the data of the scripted table (always only one row) depends on the outer table.

now i need to pass the row from the nested table to the outer table to finally sum all of them up in an aggregation.

is this possible?

regards
Lukas

Find more posts tagged with

Comments

mwilliams

Hi Lukas,

You should be able to increment a variable and recall it in the outer table when you want to display the total.

Let me know if you have questions.

waldemar

thanks for your fast reply!

i have antoher question:

is it possible to show the value of the nested table in a column of the outer table.
so that i can work with assertions on this column?

mwilliams

Lukas,

Have you tried storing a value in a persistent global variable and recalling it in a dynamic text box in the outer table? I haven't made sure this works, just suggesting.

waldemar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66169" data-time="1278432846" data-date="06 July 2010 - 09:14 AM">
Lukas, 
 
Have you tried storing a value in a persistent global variable and recalling it in a dynamic text box in the outer table? I haven't made sure this works, just suggesting.

</blockquote>
 
well, it works that way you suggested. 
but i'm afraid i can't use the dynamic text box to implement an aggregation because it's no part of the data set used in this table. 
i also tried to set a report parameter and further more a report variable. 
you can use both of them to show the value of the nested table in the outer table but 
again an aggregation doesn't really work. 
 
i really appreciate and need your help beacause I'm stuck in the deepest dark

are there any more ideas?

mwilliams

Lukas,

Can you set up a report with a similar setup to the report you're working on, only with the sample database so that I can work with it to help you get what you're wanting?

waldemar

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66204" data-time="1278514052" data-date="07 July 2010 - 07:47 AM">
Lukas, 
 
Can you set up a report with a similar setup to the report you're working on, only with the sample database so that I can work with it to help you get what you're wanting? </blockquote>
 
thanks for your help! 
 
for each customer (outerTable) in the nested tables (nestedTable1, nestedTable2) his orders are listed up. 
for each orderposition i fetch the price via the scripted dataSet (Sales) and its Eventhandler (Sales_Eventhandler.java) from the accountingsystem based on the ordernumber and display it in the nested tables (salesTable1, salesTable2). In this example as sales values only the id of the ordernumber is returned from the eventhandler. 
 
now i want to display the fetched values in the column (yellow marked) on the right-hand side to finally sum them up with an aggregation at the bottom of the nested table (nestedTable1, nestedTable2). 
 
regards, 
lukas

mwilliams

Lukas,

What is your BIRT version?

waldemar

I'm working with version 2.5.1

thuston

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66520" data-time="1279308085" data-date="16 July 2010 - 12:21 PM">
Lukas, 
 
What is your BIRT version? </blockquote>
Check the XML of the rptdesign - <property name="createdBy">Eclipse BIRT Designer Version 2.5.1.v20090903 Build <2.5.1.v20090922-0630></property>