Cannot Summarize a Subreport Summary Field

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!

zriveraAsked:
Who is Participating?
 
frodomanCommented:
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
 
zriveraAuthor Commented:
That did the trick, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.