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
Myself find out answer using replace expression to achieve my output
My Expression Code:
=Replace(Fields!Calc_BillToAddressList.Value,"~",vbCrLf)