display new line in report

hello i'm building new report using report builder i need to retrieve my data from database and displa it in a table. all thing is allright but i have one problem. i have one feild contain new line ( char (13) ) from data base (the char(13) is contained in the data retrieved from database) but the report builder didn't display the new line in the output report

i'm using mssql 2008 R2 the data are displayed in multiple lin开发者_如何学Ce in mssql and visual studio

any idea ?

Well, as I understood, MS Report Builder does not understand special symbols. Instead for new line you should use "vbCrLf" constant (http://msdn.microsoft.com/en-us/library/dd255261(v=sql.100).aspx)

You should replace the char(13) with <br/> somewhere before you display it.