Page 1 of 1

Problem getting group sum value

Posted: Thu Nov 05, 2009 2:48 am
by ringo
Group 1
Group 1-1
Group 1-1-1
--- 100
--- 200
Group 1-1-1 total 300

Group 1-1-2
--- 102.5
--- 103.5
Group 1-1-2 Total 206
Group 1-1 Total : 506

Group 1-2
Group 1-2-1
--- 150
--- 100
Group 1-2-1 total 250

Group 1-2-2
--- 202
--- 303.5
Group 1-2-2 Total 505.5
Group 1-2 Minimum of Group 1-2 : 250
Group 1 Total = Group 1-1 value + Group 1-2 value

I can get the value of Group 1-1 and Group 1-2 but I can't get the value of Group 1 total (which is sum of Group 1-1 and Group 1-2).

It's urgent and I need to submit this report to my boss by next week, please help.

ringo



Problem getting group sum value

Posted: Thu Nov 05, 2009 6:03 am
by Edward
Hi Ringo,

In case if the expression is placed in the appropriate GroupFooter band then you receive sum of each group what is ok.

But if you need a Total sum of the DataBand then just place Footer Band right after the DataBand with appropriate expression in it.

In case if you need that sum in the Header of the report, then please use the following expression:

{Totals.Sum(DataSource,expression)}

Please see attached report.

Thank you.

Problem getting group sum value

Posted: Thu Nov 05, 2009 11:31 pm
by ringo
Hi Edward,

Thanks for your reply.

But I can't download the attachment.

ringo

Problem getting group sum value

Posted: Fri Nov 06, 2009 2:03 am
by Andrew
Hello,

I've just checked it and everything can be downloaded.

Please try to do it once again.

Thank you.