<b>Second sort on the field</b>

[hpai]

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

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

Except Employee.LName, I also want Employee.FName to be the second sort. How do I add Employee.FName into my formula?

 

[dgillz]

Create a formula field called EmployeeFullName and concatenate the two names -- {Employee.LastName}+" "+{Employee.FirstName} then change your existing formula:

If {?Sort By} = "Name" Then {@EmployeeFullName}
Else {ORegion.ID}



Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine