asked on

Crystal XI sub-report shared currencyvar not returning value to main report

Main report contains the following @Material Costs formula:
IF ISNULL(Sum ({@Misc Costs}))
THEN {@PO Value}
ELSE IF ISNULL ({@PO Value})
THEN Sum ({@Misc Costs})
ELSE Sum ({@Misc Costs})+{@PO Value}

The formula @PO Value is simply...
shared currencyvar povalue

The Job Matl Sub-report contains the following formula:
@Value
{POReleases.Qty}*{PODet.UnitCost}

@SumPO
shared currencyvar povalue;
Sum ({@Value})

My main report formula @PO Value is supposed to pass the shared currencyvar povalue to the @Material Cost formula; however, I'm only getting the @Misc Cost... missing the Sum ({@Value}) from the Job Matl Sub-report.

Not certain what I'm missing?
Job-Cost-Actual-vs-Estimate.rpt

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Lee Ingalls

ASKER

I placed a formula @poval in RHa, which declares shared currencyvar povalue.
I'm not concerned (for now) with the work centers, etc in (GH1). So long as their columns SUM to RFa to be used in @Total Labor.

RFa, contains:
@Total Labor --> Sum ({@Labor})+Sum ({@Burden})
@Material Costs simplified to --> Sum ({@Misc Costs})+{@PO Value}
@Total Costs --> ({@Total Labor})+({@Materials Costs})

Where @Material Costs, @PO Value --> shared currencyvar povalue

I understand what you're saying about Crystal processing top down... and the Job Matl sub-report needing to run before it's value is needed in RFa's totals formula; so I saved the job material sub-report as Job Matl Subrpt2 and placed it in RFd and placed the original Job Matl Subrpt in RHb.

Unforntuately with the exact same results... @Material Costs is only picking up @MiscCosts values; still no value from shared currencyvar povalue.

My heads spinning.
Doc6.pdf

Mike McCracken

Can you upload the report with some saved data?

mlmcc

SOLUTION

James0628