I just started using the SSDT Data Tool and am wondering how to write expressions. What I'm trying to do as a test is create a small report using Vendor Contact info. There are 3 address fields then a city, state and zipcode. I wish to string together all three address fields as long as there is data in each one of them. I have NO idea how to write this expression.
The report will look like this:
Name Address City, State ZipCode Phone Fax
xxxxxxx xxxxxxxxxx xxxxxxxx, xx, xxxxx (999) 999-9999 (999) 999-9999