Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sherrys
Starting Member
37 Posts |
 Posted - 2006-05-02 : 11:28:52
|
| I am using SQL 2000 Reporting services. I am trying to show a person's address with a carriage return before the city. The address column is a varchar(400) and has already been concatenated from several attributes. I have tried inserting a char(10) + char(13) in the sql that builds the table. This appears to have no effect in the displayed and printed report. I have tried inserting a '<br>'. This just shows the <br>. I have looked around to see if there is a richtextbox control that I can add to my tool box. It seems I would have to pay for it. Anybody been here?Thanks,Sherry |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2006-05-02 : 16:29:24
|
| I would suggest you just split out the field in T-SQL select to make it into two fields, then you map them to different textbox fields on the report, which could sit on any locations you want. |
 |
|
|
|
|
|
Rich Text Box for Carriage Returns