SQL Server Performance Forum – Threads Archive

Carriage Returns in textboxes

Hi, I’m new to this forum and I hope somebody can help me. Before using reporting services if I wanted a carriage return in my html textboxes, I simply added <br> to the database varchar field. The browser replaced the <br> with a carriage return in the html output.
However reporting services just prints <br> in the textbox. Is there a code I can use in reporting services that the application will replace with a carriage return ? Or maybe theres a better way of doing this ?
Many thanks in advance for any help, Steve.

---

maybe you can try to add chr(13)

---

Ive just done that very thing ….. it formats the html nicely, but still doesnt insert a linebreak in the displayed data So Im looking for a way of inserting a break Anyone ? Graham

---

Ive just looked at the microsoft newsgroup ->http://www.microsoft.com/sql/commun…x?dg=microsoft.public.sqlserver.reportingsvcs and found the answer there ….. insert a vbCRLF – it gets rendered as a linebreak hurrah
Graham

---

]]>