Hi all, I am working on a Birt report that requires me to grab aggregated values from a child table to be used as part of a calculation in the parent table. I tried using variables to grab the values but it doesn't work as intended. The variables does not update itself with the aggregated values from the child set immediately.
Is there any way to do this?
Any help will be much appreciated.