Home » CR XI, Crystal Reports

How to sort the report based on ASCII values.

14 March 2009 No Comment

Symptom

CR by default will not sort the report based on ASCII values.

Dificulty:

Intermediate – Expert

Workaround:

You need to create a formula with following code :
Â
ASC({tablename.fieldname})

Sort the report based on this field. Now, you can see that the report is sorted based on ASCII values.

Above steps will help to sort the report based on ASCII values.

Â

VN:F [1.7.7_1013]
Rating: 0.0/10 (0 votes cast)
VN:F [1.7.7_1013]
Rating: 0 (from 0 votes)
Translate this post
        
        
        
        
  

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.