Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 3 fields in 1 expression help

Author  Topic 

hbadministrator
Posting Yak Master

120 Posts

Posted - 2013-01-29 : 14:35:44
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
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-29 : 14:58:23
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
Posting Yak Master

120 Posts

Posted - 2013-01-29 : 15:21:12
perfect
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-29 : 23:53:28
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
   

- Advertisement -