Second sort on the field

[hpai]

Hi,
I use a parameter field to change my sorting like following:

If {?Sort By} = "Last Name" Then {Employee.LName}
Else {Region.ID}

Except Employee.LName, I also want a second sort for Employee.FName. How do I add Employee.FName into this formula?

 

[Ngolem]

I assume you are putting this into the sort expert...or alternatively you could create a group on this formula

If {?Sort By} = "Last Name" Then
{Employee.LName} + "/" + {Employee.LName}
Else
{Region.ID};

if you base your sorting on this formula as a group...you will see the lastname/firstname in the tree of the report