|Passing sub report totals to expressions [message #931311]
||Wed, 03 October 2012 00:58
| Jeff Stouse
Registered: May 2012
(fairly new to BIRT - as you will see below)
I have a settlement report I am trying to generate. In it, I have several queries that pull out single field values, which then need to be added/subtracted from other values, or from a sum of values from a subreport table. I know I am missing the obvious, but how do I:
--> Assign the sum of a related (child) table's rows to a variable that can then be accessed in an expression which subtracts/adds it to values from the master table?
For example, I have a created a query which pulls out two preliminary payments (first and third) and then I add them together. This value then needs to have the sum of expenses (I have a child table with an aggregate of the expenses nested in the master table) subtracted from it. I cannot figure out how to access the sum of the nested tables expenses in the expression.
Any and all help greatly appreciated - please point out what I've been missing/don't understand so far.
Powered by FUDForum
. Page generated in 0.02145 seconds