1

I have a SSRS report that has one very large textbox on it. Is there a simple way to display gridlines between each line break?

Example: https://i.stack.imgur.com/ON7Ho.jpg

The only solution I can think of is to have 3 separate textboxes and use Len() to break up the text between the 3. This would be extremely tedious as I actually have 14 lines and they span the width of the page.

Thanks in advance!

Christine P
  • 11
  • 1

1 Answers1

0

You can split the text data into separate rows within your dataset using TSQL as described in the answer to this question: Turning a Comma Separated string into individual rows

Instead of a comma, you're splitting on the linefeed character which you can reference as char(10).

Note: You may need to strip out carriage return characters char(13), too.

Community
  • 1
  • 1
JC Ford
  • 6,946
  • 3
  • 25
  • 34
  • Thanks, I was hoping there was a way to do this without having to parse the text and the dataset I'm working with is extremely large, so I'd rather not use recursion. I'll give this a go though! – Christine P Mar 10 '14 at 17:07
  • I understand SSRS 2008 adds support for some HTML and CSS. Maybe you could inject some `

    ` tags into your text by doing a replace on linefeed.

     – JC Ford Mar 10 '14 at 19:50