How to display string instead of numeric value of column body in the report viewer RRS feed

  • Question

  • I made a report using report viewer.

    A column is mapped to the integer value.

    However I want to show that column as string.

    For example, if the Direction value is 1, it should be displayed as "outgoing" and 2, as "incoming".

    Something should be done in the expression but don't know how to do it.

    Here is the screen capture of the report viewer.

    • Edited by Jeff0803 Monday, September 2, 2019 3:45 AM
    Monday, September 2, 2019 3:41 AM


  • Check if there is an “IF” or “IIF” operator or function. (Expand the “Operators” and “Common Functions” nodes). Maybe you can write this:

       =IIf(Fields!direction.Value=1, "outgoing", "incoming")

    • Marked as answer by Jeff0803 Tuesday, September 3, 2019 4:21 AM
    Monday, September 2, 2019 5:21 AM