Link to home
Start Free TrialLog in
Avatar of BlakeMcKenna
BlakeMcKennaFlag for United States of America

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
Avatar of ValentinoV
ValentinoV
Flag of Belgium image

I have the impression you might be mixing two different tools, which is quite normal because their names are rather confusing.

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:

... provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries.
What you'll probably want to install: Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012
ASKER CERTIFIED SOLUTION
Avatar of FriedTyGuy
FriedTyGuy
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BlakeMcKenna

ASKER

That worked!

Thanks!