Solved

Writing expressions using the SSDT tool

Posted on 2013-11-18
3
401 Views
Last Modified: 2013-11-20
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
Comment
Question by:BlakeMcKenna
3 Comments
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39658639
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
 
LVL 1

Accepted Solution

by:
FriedTyGuy earned 500 total points
ID: 39663791
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
 

Author Comment

by:BlakeMcKenna
ID: 39664420
That worked!

Thanks!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now