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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Join fields

Author  Topic 

sz1
Aged Yak Warrior

555 Posts

Posted - 2012-11-13 : 04:21:16
Hi,
I'm trying to do a simple join first anme with last name in an expression, I tried this:
=First(Fields!Contact_First_Name.Value, "DataSet1") +' '+ First(Fields!Contact_Last_Name.Value, "DataSet1")

and

=First(Fields!Contact_First_Name.Value, "DataSet1") +" "+ First(Fields!Contact_Last_Name.Value, "DataSet1")

and

=First(Fields!Contact_First_Name.Value, "DataSet1") &" "& First(Fields!Contact_Last_Name.Value, "DataSet1")

none work?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2012-11-13 : 05:41:23
First hit on google:
http://www.katieandemil.com/ssrs-concatenate-two-string-fields-using-expression


Too old to Rock'n'Roll too young to die.
Go to Top of Page

sz1
Aged Yak Warrior

555 Posts

Posted - 2012-11-13 : 07:24:54
Yeah found it thanks.
All sorted.
Go to Top of Page
   

- Advertisement -