Calculating Sum for Multiple Tables

khitch

<p>Hi, I have three tables and three datasets that I want to grab values from and calculate the sum of those values onto another table.</p>
<p> </p>
<p>I know this is done somehow using scripting but I'm unsure exactly how as I'm new to this.</p>
<p> </p>
<p>Any help?</p>
<p> </p>
<p> </p>
<p>*edit - did the calculation in sql using select within select and sum, instead of in BIRT - it worked</p>
<p>problem solved</p>

micajblock

<p>BTW, in case you are curious, this can be done with either global variables or report variables. You set the variables in the onCreate of the first 3 tables and use it in the 4th table.</p>