3 fields in 1 expression help - SQL Server Forums

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

hbadministrator
Posting Yak Master

120 Posts

Posted - 2013-01-29 : 15:21:12

perfect

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources