Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Don't flaunt your success, but don't apologize for it either
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

The Maximum Impact Solutions Blog Feed ME!!!!


How Do I Sort a Memo Field in Crystal Reports?

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


Name *

Email Address *

Comment *

To prove you are human what is:

63 + 70 =