08 January 2010 09:37 okeofs

SQL Server Reporting Services Reading linebreak in textbox

The Problem 

 We are loading data from a single data element into a textbox that can contain html linebreak tags (<br />). Is there a way for reporting services textbox to read this and insert line breaks so that it displays as paragraphs? Is the textbox capable of acting on any character codes (as in a rich textbox)? Do I have any workaround options? Am I going to have to change the app to save the data to multiple records just to be able to display the data to multiple textboxes so that it shows as multiple paragraphs? 

My Solution

Hi
A quick one..
Are you loading this by utilizing as Visual Studio application.
If so what I would suggest is to replace the <BR/ > with a chr(13).
i.e. The cat and the big black dog <BR/>
   String mystring =  "The cat and the big black dog " +  chr(13) ;

Please give this a try and let me know how you fare.

Should you wish to get hold of me njm870t@hotmail.com or ssimon@statestreet.com

sincerest regards
Steve Simon      

 

Comments

# Dew Drop &#8211; January 9, 2010 | Alvin Ashcraft&#039;s Morning Dew

Pingback from  Dew Drop &#8211; January 9, 2010 | Alvin Ashcraft&#039;s Morning Dew

# re: SQL Server Reporting Services Reading linebreak in textbox

17 February 2011 09:52 by rickchild

If you are using SSRS2008 then you may navigate to Placeholder Properties, and choose HTML - Interpret HTML Tags as Styles.

You may then use basic HTML tags such as <br> to be interpreted by SSRS and applied during rendering.

Please see the URL, credit to Melissa Coates