Unable to Add New Line Character in SQLServer 2005 Reporting Services
-
Hi
Unable to Add New Line Character in SQLServer 2005 Reporting Services TextBox control.
My Problem is:
In my report page i have to show the Address of the Customer. I have filed in the database Address1, Address2 , Address3 , Town , City fields...
I tried to show all the 5 fields in one text box.
For me Data's are comint but the new line character not adding the database.. I written expression's as follows
= Fields!Address1.Value & Chr(13) & Fields!Address2.Value & Chr(13) & Fields!Address3.Value & Chr(13) & Fields!Town.Value & Chr(13) & Fields!City.Value
( And Triied with Text Height also Right click text box -> Format -> Textbox Height -> Can Increase to accommodate contents / Can Decrease to accommodate contents -> Uncheck/Check that also it is not working.)
I tried with different textbox each field. But If Address3 is not having the data that time i have to move the Town field information to the address3 field place. If I used different textbox means it is giving empty text box for null value fields
Please send your Suggestions to following mail id's sundaraguru_s@apollohealthstreet.com and sundharmail@yahoo.co.in.
Advance Thanks
Kind Regards
Sundaraguru S
-
This was removed by the editor as SPAM
-
try vbcrlf instead of Ch(13). I don't think it's the most up to date method but it works.
-
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply