How do I sort on a combined user report field?
When creating a user defined report, label, view, etc., you typically will want to use one of the combined smart fields that automatically display the full name, or "last name, first name", or that combines the city, state, and ZIP code, etc.
That's great for display, but what if you want to sort on just one of the fields that are "part of" the combined field you selected? How do you do it?
The answer is simple: use a hidden field!
For example, say you are using the smart field "City/State" for one line of a mailing label report, but you want to sort the labels by State. Since the state isn't the first thing displayed in the field, you can't just sort on this field because that is effectively sorting by City.
To solve the problem, do the following after adding your normal fields:
1.Add the State field somewhere on the label.
2.Set that field as hidden.
3.Set that field as the 1st sort
Now you have an invisible field that is only used for sorting, leaving your display fields unchanged.
See User Defined Reports for details.