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