• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 452
  • Last Modified:

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
0
BlakeMcKenna
Asked:
BlakeMcKenna
1 Solution
 
ValentinoVBI ConsultantCommented:
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
0
 
FriedTyGuyCommented:
Right click on the field and selected expression.  An expression builder pop up will get you there.  I'm assuming your using VS2012/2013 which requires SSDT to build reports for SSRS.
0
 
BlakeMcKennaAuthor Commented:
That worked!

Thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now