Search code examples
reporting-servicesssrs-tablixssrs-2014

Line break based on symbol in ssrs report


Hi I am new to SSRS Report i have to apply line break on table column field based on some symbol(~) . I dont know how to write expression for this

    Medline Industries, Inc.~email inv to:
    [email protected]~Attn: A/P Priority
    A~PO Box 876~Mundelein IL 60060-0876~USA~~

    **To change like below based on ~:**

    Medline Industries, Inc.
    email inv to:[email protected]
    Attn: A/P Priority A
    PO Box 876
    Mundelein IL 60060-0876
    USA

Solution

  • Myself find out answer using replace expression to achieve my output

    My Expression Code:

    =Replace(Fields!Calc_BillToAddressList.Value,"~",vbCrLf)