Solved

# Sum of a summarized field in Crystal Report 11

Posted on 2008-10-22
1,125 Views
Hi,
I'm new to Crystal reports and I am trying to get a total sum of a number of sums.
So far I have
Counterparty:  ID A
{start time} {end time} {Quantity1] //this breakdown of detail is hidden in the subreport
{start time} {end time} {Quantity2} //this breakdown of detail is hidden in the subreport
{start time} {end time} {Quantity3} //this breakdown of detail is hidden in the subreport
Sum(Quantity)
ID B
{start time} {end time} {Quantity1} //this breakdown of detail is hidden in the subreport
{start time} {end time} {Quantity2} //this breakdown of detail is hidden in the subreport
{start time} {end time} {Quantity3}  //this breakdown of detail is hidden in the subreport
Sum(Quantity)
I then need to have a Sum(SumQuntity).  Which is where I am having problems as when I try this crystal brings up an error saying that I can't summarize a summary.

Can this be done?
Any Help?
Thank you.
0
• 2

LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 22776752
Yes but you have to use variables and formulas

How do you calculate the Sum(Quantity)

You need a formula like this in the group footer
Global NumberVar ReportTotal;
ReportTotal := ReportTotal + {Sum(Quantity) formula};

Display in the report footer with
Global NumberVar ReportTotal;
ReportTotal

mlmcc
0

Author Comment

ID: 22777657
I have calculated Sum(Quantity)  by creating a formula field which includes sum({@Quantity}) as the formula.

I have tried the formula suggested but I just get a value of 0.
What I would like to see is:
Counterparty:  ID A    Sum(Quantity)
ID B    Sum(Quantity)
ID C    Sum(Quantity)
TotalQuantity.
But what I see is:
Counterparty:  ID A   Sum(Quantity)
TotalQuantity = 0
ID B    Sum(Quantity)
TotalQuantity = 0
ID C    Sum(Quantity)
TotalQuantity = 0
I don't quite understand where I am going wrong.

0

LVL 100

Expert Comment

ID: 22779427
Add WhilePrintingRecords as the first line of the formula

Put the display in the report footer not the group footer.

mlmcc
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question