The issue:
A client needed to sort a memo field in their Crystal Report report.
However as memo fields, can contain upto 64,000 characters, and so cannot be indexed, and it is because of this that memo fields cannot be sorted.
The solution:
What is really needed to to take a sample of the memo field contents, and as text fields are indexed with 256 characters.
Using this we created a formula, to take the first 100 characters of the memo field, using the formula:
LEFT({TableName.Memofield}, 100)
This formula field could then be used for sorting the report.
If you have any questions, leave us a comment below, or need any assistance, please do not hesitate to Contact Us | 
