If all names are separated by a semi-colon, you can use CharIndex to find the position of the semi-colon and either Left or Substring to extract the surname.
In the future you might get a quicker response to this type of question in forum183 instead of this form, since this forum specifically deals with Reporting Services.