Getting values from other datasets/tables

smartinez7

<p><span>Hello,<br />
<br />
I need help with my report. I have three datasets/tables in my report. Each dataset has an amount that I would like to do get and and put into a fourth table with for a remaining balance. So I will show an example below.<br />
<br />
<br />
DataSet1/Table 1<br />
Vendor , Description, VendorID, <strong class='bbc'>Purchase Limit</strong><br />
<br />
DataSet2/Table 2<br />
Vendor, Description, VendorID, <strong class='bbc'>Spent Amount</strong><br />
<br />
DataSet3/Table<br />
Vendor, Description,VendorID, <strong class='bbc'>Invoice Amount</strong><br />
<br />
I want to have a 4th table or insert a data binding that has a remaining balance of<br />
<strong class='bbc'>Purchase Limit</strong> - <strong class='bbc'>Spent Amount</strong> - <strong class='bbc'>Invoice Amount</strong> = Remaining Balance for Vendor<br />
<br />
I don't know how to get attributes from different tables, can anyone help, please?<br />
<br />
I have attached my design file. Any help would be greatly appreciated. I'm using BIRT 3.7.1</span></p>

kclark

<p>In the initialize() you could create three ArrayList PGV's like this

</p><pre class="_prettyXprint _linenums:0">var array1 = new java.util.ArrayList();var array2 = new java.util.ArrayList();var array3 = new java.util.ArrayList();reportContext.setPersistentGlobalVariable("array1", array);reportContext.setPersistentGlobalVariable("array2", array);reportContext.setPersistentGlobalVariable("array3", array);</pre>
Then recall each of them in the onRender() of purchase limit, spent amount, and invoice amount.

<pre class="_prettyXprint _linenums:0">var purchaseLimit = reportContext.getPersistentGlobalVariable("array1");purchaseLimit.add(this.value());reportContext.setPersistentGlobalVariable("array1", purchaseLimit);</pre>
Then do the same for the other two and you should be able to call these back to preform some calculations with them later in your report.