How to replace any symbol to break-line?

Isaland Member Posts: 52

2012-08-30 edited 2012-09-04 in NAV Three Tier

Hello. I have a small question.
How can I replace in RDLC some symbol to break-line?

For example, my value is:

John Web\7865 Jackson Str.

And when i put this value in some function, it will show textbox like this:

John Web
7865 Jackson Str.

MB7-840

0

Best Answer

• 

  clausl Member Posts: 455

  2012-08-30 Answer ✓

  Try this:
  http://www.bidn.com/blogs/DustinRyan/ssis/792/using-the-chr-function-to-encode-a-carriage-return-line-feed-or-double-quote-in-an-ssrs-expression
  
  /Claus Lundstrøm

  Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
  I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
  I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)

  1

Answers

• 

  clausl Member Posts: 455

  2012-08-30 Answer ✓

  Try this:
  http://www.bidn.com/blogs/DustinRyan/ssis/792/using-the-chr-function-to-encode-a-carriage-return-line-feed-or-double-quote-in-an-ssrs-expression
  
  /Claus Lundstrøm

  Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
  I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
  I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)

  1
• 

  Isaland Member Posts: 52

  2012-08-31

  clausl wrote:

  Try this:
  http://www.bidn.com/blogs/DustinRyan/ssis/792/using-the-chr-function-to-encode-a-carriage-return-line-feed-or-double-quote-in-an-ssrs-expression
  /Claus Lundstrøm

  
  Thank you :thumbsup: It was usefull

  MB7-840

  0
• 

  clausl Member Posts: 455

  2012-08-31

  Great
  
  /Claus Lundstrøm

  Claus Lundstrøm | MVP | Senior Product Manager | Continia.com
  I'm blogging here:http://mibuso.com/blogs/clausl and used to blog here: http://blogs.msdn.com/nav
  I'm also offering RDLC Report Training, ping me if you are interested. Thanks to the 700 NAV developers that have now already been at my training. You know you can always call if you have any RDLC report issues :-)

  0
• 

  mihail_kolev Member Posts: 379

  2012-09-03

  you can also use System.Environment.NewLine

  -Mihail- [MCTS]

  0
• 

  Isaland Member Posts: 52

  2012-09-04

  mihail_kolev wrote:

  you can also use System.Environment.NewLine

  Thanks for tip, but i already use Split() function with chr(10) & chr(13)

  MB7-840

  0