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
Problem getting group sum value
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.
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
Problem getting group sum value
Hi Edward,
Thanks for your reply.
But I can't download the attachment.
ringo
Thanks for your reply.
But I can't download the attachment.
ringo
Problem getting group sum value
Hello,
I've just checked it and everything can be downloaded.
Please try to do it once again.
Thank you.
I've just checked it and everything can be downloaded.
Please try to do it once again.
Thank you.