asked on

Sum of a summarized field in Crystal Report 11

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.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

aditi55

ASKER

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.

Mike McCracken

Add WhilePrintingRecords as the first line of the formula

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

mlmcc