The summary/running total field could not be created

[Hillary]

Does anyone know why Crystal won't sum this?

Shared NumberVar RunTime:= {OPERATION.RUN};
Shared StringVar RunType:= {OPERATION.RUN_TYPE};
Shared NumberVar Quantity:= {WORK_ORDER.DESIRED_QTY};

If RunType like "MIN/PC" then Sum((RunTime*Quantity)/60)

Thanks for your help.

Hillary

 

[synapsevampire]

You're using shared variables, which implies that these values are being passed from a subreport, which may be part of your problem.

I'll assume that you don't need shared variables, and that you just want to sum a formula, so create a formula with:

if {OPERATION.RUN_TYPE} = "MIN/PC" then
{OPERATION.RUN*{WORK_ORDER.DESIRED_QTY}}/60
else
0

Now you can place this formula in the details and right click->Insert-Sum, etc. to insert sums at group or report levels.

If you are needing the shared variables to be summed, you'll probably have to create a formula to sum them up for you.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[chelseatech]

If you do need the shared variables you will need to sue some more variables as accumulators Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm