Wednesday, March 11, 2015

To set multiple line in a textbox in SSRS

If we want to have multiple line in a single text box in report like below:

Name:      Address:   City:      State:    ...
Jon Doe    Addr1      ThisTown    XX       ...    
               Addr2
               Addr3
-----------------------------------------------
Jane Doe   Addr1      ThisTown    XX       ...
               Addr2
               Addr3
-----------------------------------------------

We can use the & VbCrLf & between the expression as given below which works fine. 

= Fields!Addr1.Value & VbCrLf & 
   Fields!Addr2.Value & VbCrLf &
   Fields!Addr3.Value