Creating addresses for a single cell

Put this in your query

third.Address1 + CHAR(13) + ISNULL(third.Address2, '') + CHAR(10) + CHAR(13) + third.City + ', ' + third.State + ' ' + third.ZipCode + CHAR(10) + CHAR(13) + ISNULL(third.Company, '') + '  ' + ISNULL(third.Country, '')  + '  ' + ISNULL(third.Phone, '') AS ThirdPartyAddress

In this block of a query, we needed to simplify and crunch down the needed table cells to display a company’s full address. This is done by aliasing the entire table’s values to one address value, called ThirdPartyAddress. 

The + CHAR(10) + CHAR(13) + goes to a new line, so our address doesn’t run on and look messy .

You can also do it line by line and insert them as expressions like so

Name

Adr1

Adr2

City, State, Zip

etc. 

The beauty about SSRS is that on the surface it doesnt seem like it can do much compared to Crystal Reports in terms of formatting, and this may be true, but it is powerful and can replicate the formatting of many Crystal Reports. Just be mindful of the computers/Report Server/customer machines which can upset the formatting when deployed or ran.