Crosstab: Issue getting shared variable value to display

[Oscar115]

Crystal XI

I have a subreport. The subreport returns a shared numbervar: shared numbervar sumofcode10peramp;
sumofcode10peramp := sum({@Billed 10 per code},{lrunit.cAmpkey})

where {@Billed 10 per code} is
if ({lrtran.ctrancode} = '10' and {lrtran.crefno} startswith {@Month Number Description} and {lrtran.namount} > 0.00)
or
({lrtran.ctrancode} = '10' and not ({lrtran.crefno} startswith ["01", "02", "03", "04", "05", "06", "07", "08", "09", "10", "11", "12"]))
then {lrtran.namount}


The value of that shared numbervar displays correctly in the details of the report and is used in calculations of the report. However when I put any calculations based upon the shared numbervar or the shared numbervar into the crosstab, the value of the shared numbervar becomes zero within the crosstab.

Thanks,
Oscar

 

[lbass]

Crosstabs are processed before shared variables, so you can't reference shared variables in crosstabs.

-LB

 

[Oscar115]

Thanks LB, I appreciate the information!