Monday, March 12, 2012

joining 2 textfield into 1

hi, i need help in join the last name and given name.
for crystal report we can join the given name and last name by draging the datafield into a label and the name is joined. but as for reporting services how can i do that. i try adding 2 datafield into a text field an error occurred. so is there any other alternative?
Your regards
Angiewhat do you have currently? You can either do it in the query itself as
SELECT
FirstName + LastName AS [Name]
FROM
..
Or in RS you can concatenate them as :
=Fields!FirstName.Value & Fields!LastName.Value
|||thanks...i'll give it a tryBig Smile [:D]

No comments:

Post a Comment