Need new line in email address

• giszzmo

  SSChasing Mays

  Points: 647

  More actions

  July 25, 2014 at 2:31 pm

  #296743

  I have an SSRS report where one column is an email address. I need to make the email addresses do two lines where they start a new line at the @ sign. This did not work for me: =Fields!Email.Value & chr(10) & chr(13) & "@"

  I have: name@yahoo.com

  I want:

  name

  @yahoo.com

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  July 25, 2014 at 2:34 pm

  #1732536

  I can't verify, but try this ...

  =REPLACE(Fields!Email.Value,"@", vbCrLf & "@")

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg