Sorting on a formula field
Posted: Wed Jan 05, 2011 10:23 am
I have the following expression that I use to display owner or entity.
{IIF(Parcel.[Entity Name] != string.Empty, Parcel.[Entity Name], Parcel.[First Name] + " " + Parcel.[Last Name])}
I'd like to be able to sort (A-Z) on this field, but since it's an expression in a text field I don't see a way to do it. What's the method to sort based on a text field with an expression in it?
{IIF(Parcel.[Entity Name] != string.Empty, Parcel.[Entity Name], Parcel.[First Name] + " " + Parcel.[Last Name])}
I'd like to be able to sort (A-Z) on this field, but since it's an expression in a text field I don't see a way to do it. What's the method to sort based on a text field with an expression in it?