CODEWITHSUNDEEP
sql-serverssrs-2008reportbuilder
Mouhamad Lamaa
Mouhamad Lamaa

Reputation: 884

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 line in mssql and visual studio

any idea ?

Upvotes: 0

Views: 5066

Answers (2)

Vita1ij
Vita1ij

Reputation: 392

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)

Upvotes: 4

Hogan
Hogan

Reputation: 70528

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

Upvotes: 0

Related Questions