Sometimes we need to print informations like...
Name Address1, Address2, City ... etc.. in this format.
In SSRS, Put one Text Box and set expression. In expression use VBCRLF OR Chr(10) for new line create.
e..g: "Alpesh Gorasia" & VBCRLF & "Ahmedabad" ....etc..
While the VbCrLf makes sense, I would not use just the Chr(10) but chr(13) + chr(10) CR and Lf
vbCrLf is Chr(10) + Chr(13). I prefer the vbCrLf because it is a system constant and doesn't call any functions like "CHR()". Chr(10) is the End-Of-Line for UNIX platforms, it is also vbLf.
vbCrLf
Chr(10) + Chr(13).
Chr(10)
vbLf
You don't know the format that the user is going to request their data in: They could set the output format to be CSV, Excel, PDF or HTML. Whatever you choose needs to work in all four.
Since CSV uses a CRLF ( vbCrLf or Chr(13) + Chr(10) ) as a row seperator, using it within a report is a BAD IDEA. Excel may also have problems with it.
It would be better to have a number of stacked controls
Thank you all,
I agree with marc_jellinek that output format in CSV, Excel display bad. Basically such type of requirement use in any document type report like..Statement,Invoice,Letter etc... so generally this type of report set the output format to be PDF or WORD.