Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Cannot Summarize a Subreport Summary Field

Posted on 2006-04-12
Medium Priority
748 Views
I have several assemblies that each require multiple components.  I am calculating The extended cost per assembly in a subreport.  The subreport has the cost per component calculated by @costper := QuantityPer*STDCost.  Then I have the footer summing the total cost per assembly as Sum(@costper).  Next I have a calculation of Value Remaining as Sum ({@compCostperAss})*{?Pm-@Balance}.  This last item is being passed from the main report and is calculating what is left.  So that if I have built 5 assemblies but need 10, I am getting the value of the work left.  I am passing it to the main report as a formula in the footer:

WhilePrintingRecords;
Shared NumberVar SubTotal;
Subtotal := Sum ({@compCostperAss})*{?Pm-@Balance};
Subtotal

What I want to do now is show a total sum of this last item in the main report.  In details B I have a supressed field that shows:

WhilePrintingRecords;
Shared NumberVar Subtotal;
SubTotal

But when I try to summarize the field above in the main report it says "This field cannot be summarized."

300 pts because it's urgent!

0
Question by:zrivera

LVL 42

Accepted Solution

frodoman earned 1200 total points
ID: 16440290
You cannot summarize any formula that is calculated during the WhilePrintingRecords step because that's the last step of the report engine.  What you'll want to do is add a variable and calculate your total manually.  Something like this:

WhilePrintingRecords;
Shared NumberVar Subtotal;
Shared NumberVar Grandtotal;
Grandtotal := Grandtotal + Subtotal;
SubTotal

Then you can show the total in the bottom of the report with the Grandtotal variable.
0

Author Comment

ID: 16441141
That did the trick, thanks!
0

## Featured Post

Question has a verified solution.

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

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Loops Section Overview
Screencast - Getting to Know the Pipeline
###### Suggested Courses
Course of the Month20 days, 17 hours left to enroll