Hi, I want to show Tabs in text box value.

Hi, Please provide more details. Are you having issues with displaying spaces that comes from data field? Please detail. Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

HI Actually I want to show some text in textbox which shows VbTab as string separator for eg. = "String1" & vbtab & "String 2" and in report it shoud show String1 String 2 But when I am trying, it replaces the multiple spaces with single space

Hi, Thats how tab in intepreted in rendering. I would suggest to use the space function to insert the number of desired space. = "String1" & space(10) & "String 2" May I know the reason to display the String using tab? Will it not help if different columns witin a table are used? Regards Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Not working and want to show the data in that manner only not using two columns.

Try creating a placeholder for String1 and String2 and then leave some blank space between them.

Try creating a placeholder for String1 and String2 and then leave some blank space between them.

You can do "String1" &" " &" " &"String2" Give the spaces depending on your requirement If you want string2 in new line "String1" + VBCRLF + "String2"Plz mark as Answer if your problem is resolved. Reddy

You can do "String1" &" " &" " &"String2" Give the spaces depending on your requirement If you want string2 in new line "String1" + VBCRLF + "String2"Plz mark as Answer if your problem is resolved. Reddy

Not working always shows only single space

Not working always shows only single space

Please post the expression you are using. The suggestions made so far should have worked. Another option is to convert the textbox value to placeholder text and set it to interpret HTML. You can then use line breaks <br>, paragraphs <p> and various list styles <li><ol><ul> if these serve your needs.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

Please post the expression you are using. The suggestions made so far should have worked. Another option is to convert the textbox value to placeholder text and set it to interpret HTML. You can then use line breaks <br>, paragraphs <p> and various list styles <li><ol><ul> if these serve your needs.Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com

If you want to add html the code for space is &nbsp;--- add & nbsp; nbsp; should give you 5 spaces. SSRS Developer: http://ssrsdeveloper.blogspot.com/p/sql101.html

Hi, Try writing a custom code function in SSRS for this. Call this function by a simple reporting services custom code call. Thanks.-Nitin Pawar