locked
How to change data view in a column in dependence on the value in same row another column of the table? RRS feed

  • Question


  • How to change data view in a column in dependence on the value in same row another column of the table?
    I try something like this, but it doesn't work. Where is mistake?


    Column Quantity:

    =IIf(Fields!Unit.Value="piece", Left(Cstr(Fields!Quantity.Value), Len(Cstr(Fields!Quantity.Value))-4), Cstr(Fields!Quantity.Value))


    I want to get this outcome:

    Unit Quantity
    ----  --------
    kg    1.250
    kg    1.000
    piece   1

    Thanks for any help.

    Sunday, April 29, 2007 10:55 AM