BlakeMcKenna
asked on
Writing expressions using the SSDT tool
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
xxxxxxxxxx
xxxxxxxxxx
The report will look like this:
Name Address City, State ZipCode Phone Fax
xxxxxxx xxxxxxxxxx xxxxxxxx, xx, xxxxx (999) 999-9999 (999) 999-9999
xxxxxxxxxx
xxxxxxxxxx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked!
Thanks!
Thanks!
You're referring to SSDT: SQL Server Data Tools. But these are not meant for report development.
What I think you need is called SSDT-BI, or in long: SQL Server Data Tools - Business Intelligence.
From Microsoft SQL Server Data Tools:
What you'll probably want to install: Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012