Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Believe nothing no matter where you read it, or who said it, no matter if I have said it, unless it agrees with your own reason and common sense
 
Buddha
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!!!!

17
October

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

MAKE A COMMENT

Name *

Email Address *

Comment *