?
Solved

Writing expressions using the SSDT tool

Posted on 2013-11-18
3
Medium Priority
?
440 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 2000 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

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…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 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