Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot Summarize a Subreport Summary Field

Posted on 2006-04-12
2
Medium Priority
?
748 Views
Last Modified: 2008-02-01
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
Comment
Question by:zrivera
2 Comments
 
LVL 42

Accepted Solution

by:
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

by:zrivera
ID: 16441141
That did the trick, thanks!
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question