SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 3 fields in 1 expression help		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

hbadministrator
Yak Posting Veteran

63 Posts
Posted - 01/29/2013 :  14:35:44  Show Profile  Reply with Quote
Hello I figured out how to add the Fields into 1 expression but I need to add spaces aka

=Field!City.Value & Field!St.Value & Field!zip.Value

The problem is they all run together right now.

cityPA17342

Would like to see
City, PA 17342

James K
Flowing Fount of Yak Knowledge

1527 Posts
Posted - 01/29/2013 :  14:58:23  Show Profile  Reply with Quote
Concatenate the string literals just like you did with the fields. For the example you showed:
=Field!City.Value & "  " & Field!St.Value & "  " & Field!zip.Value
Go to Top of Page

hbadministrator
Yak Posting Veteran

63 Posts
Posted - 01/29/2013 :  15:21:12  Show Profile  Reply with Quote
perfect
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
47173 Posts
Posted - 01/29/2013 :  23:53:28  Show Profile  Reply with Quote
or this
=Field!City.Value & Space(1) & Field!St.Value & Space(1) & Field!zip.Value

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000