Reports - Display first name only

Can anyone help me with the reporting module. I want to pull out an employee's first name only, but the only standard field is for all their forenames. I had a play with trying to write an expression to drop in the middle names, which worked until it came to an employee with only one forename, and then it threw an error which I wasn't able to get round. Can anyone share an expression that they've written that can do this?
  • Hi Alastair,

    Please use the following expression to display an Employees first forename only;

    Substring(Employees.Forename,0,IndexOf(Employees.Forename," ")) + " "

    I hope this helps but if you have any other questions on this please let me know.

    Regards,

    Adam
    Sage UK