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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Textbox rendering problem

Author  Topic 

chris_cs
Posting Yak Master

223 Posts

Posted - 2009-04-24 : 10:56:21
I have a text box that displays the name and address for a client on a report I have created. The SQL which generates this has a return character (Char(10)) after each line of the address, which works fine in the SQL but doesn't render on the screen.

When I print the report the name and address appears correctly with each line of the address on a different line but it isn't rendered on the screen this way. Instead it appears as one long line wrapped in the text box.

Has anyone come across this? I cannot see why I can't get the textbox displayed correctly on the screen.
   

- Advertisement -