concatenate and sort in crystal report

[eugz]

Hi All.
In my crystal report I would like to concatenate FirstName and LastName that on report it will look like:
LastName, FirstName
How to specified it in report?
Thanks.

[mabbas110]

{Fixed.LastName}+','+{Fixed.LastName}

Here Fixed would be either ur table name of proc name. Declare the formula and then define this in that formula. U can also triim it by using Trim command.

[eugz]

Thanks for replay.
It works fine. Now would like to sort that unbound concotenatad field by LastName and FirstName. How way do I need change formula to get result?
Thanks.

[eugz]

Thanks All.
Problem solved.

[mabbas110]

If my post have helped you out then please rate it and marked this thread as resolved,