none
Error 1586 RRS feed

  • Question

  • I'm passing a parameter to my report, then using that parameter to determine which value to display in the cell, but I get the following error:

     

    Error 1586: The Value expression for the textbox ‘PlanUnits’ refers to the field ‘ActualUnits’.  Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

     

    Here is my code:

     

    =IIF(Parameters!PlanValue_Parameter="Planned",
       (IIF(IsNothing(Sum(Fields!PlannedUnits.Value)), 0, Sum(Fields!PlannedUnits.Value))),
       (IIF(IsNothing(Sum(Fields!ActualUnits.Value)), 0, Sum(Fields!ActualUnits.Value))))

     

    Any help would be appreciated.

     

     

    Monday, December 31, 2007 8:34 PM