summarized total from nested datasets

been trying to do this without asking here, but i couldn't

got 3 datasets (DS1, DS2, DS3). DS3 is bounded into DS2 and this one with DS1. all this DS has numeric fields (columns) wich i need to summarized at last of each DS with some basic mathematical stuff, like this:

DS1
____DS2, Num2
________DS3, Num3
________DS3, SUM(Num3)
____DS2, totalDS2 = (Num2 - SUM(Num3))
DS1, GrandTotal = SUM( totalDS2 )

i've been trying to do it with agregates but didn't get luck. also trying to do it with some JS, but also get stucked.

can anybody point me the right way to do it, please?

any help will be very much appretiated.

Find more posts tagged with

Comments

mwilliams

Hi vladimir,

Can you attach your report design so I can see how things are set up? This will make it easier to make a suggestion. Let me know what version of BIRT you're using, so I can open the report in the correct version. Thanks!

vladimir

birt version: 2.2.2.r222_v20071226 Build

what i need:

SUM(facturas.total - SUM(pagos.cargos)) at the footer of each cliente.

now you won't see the fields/columns cuz i'm still testing.

thanks.

mwilliams

vladimir,

You should be able to do the summations the way your script is. The only thing I see is that you may run into problems by using 'var' before the variable name when you initialize it to 0. Try deleting 'var' and possibly even moving that declaration to the initialize method of the report, but it should work in the beforeFactory method as well. I'll also look for an example that I have that uses persistentGlobalVariables to pass values from one table to another and post it in here.

vladimir

Michael: 
 
thanks for your help, but it didn't help me :S

what it did help me, was this post: 
 
<a class='bbc_url' href='http://www.birt-exchange.com/forum/eclipse-birt-newsgroup-mirror/9875-total-sum-embedded-reports.html'>http://www.birt-exchange.com/forum/eclipse-birt-newsgroup-mirror/9875-total-sum-embedded-reports.html</a> 
 
thanks anyway.

mwilliams

vladimir,

Glad to hear you found a solution.