Adding a total to a column that contains a formula passed from subreport 1

[GCL2007]

Using Crystal XI, I having a hard time figuring out how to get the total of a column in a report. My issue is I have a formula @numbersprue which contains a formula @pc/sprue that is passed from a subreport. The report works fine, but I need to put a total sum at the bottom of the @numbersprue column. Having difficulty... Any thoughts???


@numberSprue formula:

if instr({Standop.OPNO}, "-10-")>0 then
{LABOR.PROCESS_QTY}
else
if {@pc/sprue}=0 then 0
else
if {@pc/sprue}<>0 then {LABOR.PROCESS_QTY}/{@pc/sprue}


Where @pc/sprue is a formula passed from a subreport

If shared stringvar sprue = " " then 0 else
tonumber(shared stringvar sprue)

 

[BobSuruncle]

Because subreports are run after any summary functions are calculated, you'll need to use variables to accumulate the values from subreports.

For example, you might modify your existing formula as follows:

WhilePrintingRecords;
NumberVar accum ;
NumberVar numbersprue
numbersprue := (
if instr({Standop.OPNO}, "-10-")>0 then 
{LABOR.PROCESS_QTY} 
else 
if {@pc/sprue}=0 then 0 
else 
if {@pc/sprue}<>0 then {LABOR.PROCESS_QTY}/{@pc/sprue}
)
accum := accum + numbersprue ;
numbersprue

Then, in your report footer, use a formula to display the accumulated value:

WhilePrintingRecords ;
NumberVar accum

Bob Suruncle

 

[GCL2007]

Thank you.. That worked out great for me....