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
 Transact-SQL (2005)
 new line in reporting services

Author  Topic 

debbieb
Starting Member

1 Post

Posted - 2010-03-24 : 06:17:22
hello,

i need to enter a new line in reporting services.
i wrote chr(10)+chr(13) in the SQL 2008.
when checked it worked nicely.
when it is runed by the customer it does not enter a new line.
the customer has SQL 2005.

waiting for an answer!!!
thank you

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-24 : 12:25:00
you can use chr(10)+chr(13) itself but it will work only when you use print or select result as text option.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-24 : 12:25:26
b/w were you asking about the new line inside report expression?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -