How to show text in next line when comma comes in the value in RDL Report

How to show text in next line when comma comes in the value in RDL Report

Posted by: opapp on 30 October 2018, 5:02 am EST

• 

  opapp

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 October 2018, 5:02 am EST

  Hi Team,
  
  Is it possible to make the text box in multi line when there is a comma comes in the text-box value in RDL Reports ?

  Currently text-box value is : abc@test.com,abc@test.com,abc@test.com,abc@test.com
  
  I want to show the value like this in text-box:
  
  abc@test.com,
  
  abc@test.com,
  
  abc@test.com,
  
  abc@test.com,
  
  abc@test.com

  Thanks

• 

  mohitg

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2018, 7:24 am EST

  Hello,

  Please use the textbox value like the following expression to achieve your requirement

  ="abc@test.com,abc@test.com,abc@test.com,abc@test.com".Replace("," ,","&Chr(13)&Chr(10))
  

  Hope it helps.

  Thanks,
  
  testEx.zip