Problem getting group sum value

Stimulsoft Reports.WEB discussion
Post Reply
ringo
Posts: 23
Joined: Mon Jun 15, 2009 4:35 am

Problem getting group sum value

Post 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


Edward
Posts: 2913
Joined: Fri Jun 09, 2006 4:02 am

Problem getting group sum value

Post 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.
Attachments
261.NestedGroupsWithTotals.mrt
(31.57 KiB) Downloaded 284 times
ringo
Posts: 23
Joined: Mon Jun 15, 2009 4:35 am

Problem getting group sum value

Post by ringo »

Hi Edward,

Thanks for your reply.

But I can't download the attachment.

ringo
Andrew
Posts: 4108
Joined: Fri Jun 09, 2006 3:58 am

Problem getting group sum value

Post by Andrew »

Hello,

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

Please try to do it once again.

Thank you.
Post Reply