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 try
![Big Smile [:D]](http://pics.10026.com/?src=/emoticons/emotion-2.gif)
No comments:
Post a Comment