You don't really say where you are doing this on your report but if you are doing this in something like a textbox, seems you would want to do this with references to the fields in the dataset itself using VBCRLF. You can find plenty of examples of that type of thing if you search on mailing labels and SSRS - you would do something similar with the labels.
Sue
Thank you for your reply.
I am trying to do in SQL side. I tried adding CHAR(13)+CHAR(10) where I want have next line behaviour. I can see the result in SSMS(text view) but when I export it to the SSRS side, the effect are gone and I am just getting the whole line of text string depending on the length of my text box. Do you happen to have any idea why it that so? Is it a limitation of it that we just simply can't use this method at all?
Because of different displays from different clients - SSMS to text is not like SSMS to grid which is not like SSRS, etc. They are all different. Some of it in SSRS is controlled though the functions, expressions using VB and some of it is in HTML. Usually the formatting will (should) be done on the client side anyway.
In SSRS, the data formatting like your example is often done with expressions. Where or how you are using it, I don't know. But it's not going to work doing it in the SQL statement. The data sets, queries are just data in SSRS.
Sue