sum group

Posted on November 22, 2006 at 12:40pm
It forgives my English, I am brazileira...
As to add the values in groups?
Code:
<br />
Father 1 -------- <br />
      Son 1 -------- <br />
         Grandson 1 -------- 5,00<br />
         Grandson 2 -------- 5,00<br />
         Grandson 3 -------- 5,00<br />
<br />
      Son 2 -------- <br />
         Grandson 1 -------- 1,00<br />
         Grandson 2 -------- 1,00<br />
         Grandson 3 -------- 1,00</td></tr></tbody></table><br />
<br />
I want to add the values above that it is in the following way:<br />
<br />
<table align="center" border="0" cellpadding="3" cellspacing="1" width="90%"><tbody><tr><td><b>Code:</b></td></tr><tr><td><pre>Father 1 -------- <b>18,00</b><br />
      Son 1 -------- <b>15,00</b><br />
         Grandson 1 -------- 5,00<br />
         Grandson 2 -------- 5,00<br />
         Grandson 3 -------- 5,00<br />
<br />
      Son 2 -------- <b>3,00</b><br />
         Grandson 1 -------- 1,00<br />
         Grandson 2 -------- 1,00<br />
         Grandson 3 -------- 1,00</td></tr></tbody></table><br />
<br />
sql are grouped by father and son and have only the value of the grandson<br />
<br />
thanks
iReport Designer
celamar's picture
celamar
4
Joined: Nov 21 2006 - 7:06pm
Last seen: 16 years 6 months ago

2 Answers:

Posted on November 22, 2006 at 1:24pm
It is possible to create a Sum in the group footer -> create a new Variable(view->variables->new and use Sum as calculation type).

As fas as I know you can only use this sum variable in the group footer(but perhaps there is a way to get a sum in the header...).
dries863's picture
dries863
152
Joined: Oct 8 2006 - 7:49pm
Last seen: 16 years 7 months ago
Posted on November 22, 2006 at 7:37pm
With the son it gave certain.
With the father it does not add when null has value =null
celamar's picture
celamar
4
Joined: Nov 21 2006 - 7:06pm
Last seen: 16 years 6 months ago
Feedback
randomness