Results 1 to 2 of 2

Thread: How to add a carriage / line feed in SSRS

  1. #1
    Join Date
    Jan 2012
    Posts
    2

    How to add a carriage / line feed in SSRS

    I have a small 20-row table in my SQL08-R2 database that has an nvarchar(max) field. Within this field, I have text with various CR/LF's (see 'sampleCRLF.png' image ).

    For some reason when I create an RDL file and drop this particular field in a 'table' within Reporting Services, sometimes the CRF/LF's display properly and sometimes they don't. I have been searching and troubleshooting with no solutions...

    All the text is showing up (in the ‘Report Preview’) with no line breaks.

    I have tried every conceivable combination in the Expression editor using the Replace function to force the break; example: '=Replace(Fields!Header01.Value, Chr(13) ,vbCrLf)'

    Any thoughts on an appropriate expression to get the line breaks to render consistently?
    Attached Images Attached Images

  2. #2
    Join Date
    Jan 2012
    Posts
    2
    I found the solution to be:

    =Replace(Fields!Header01.Value, Chr(13) ,Chr(10))

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •