Thursday, April 23, 2015

The Value expression for the text box specifies a scope that is not valid for a nested aggregate.

Custom Code

Calculated fields that are used in the expression.

WeeklyUnits

=iif(Fields!ActualDate.Value >= Parameters!BegWeek.Value and Fields!ActualDate.Value <=Parameters!EndWeek.Value and Fields!ActualUnits.Value > 0, CDec(Fields!ActualUnits.Value),CDec(0))

EstUnits and EstHours are an actual fields, (not calculated field).


-- Sam Carney

No comments:

Post a Comment