Click here to Skip to main content
13,139,834 members (54,311 online)
Rate this:
 
Please Sign up or sign in to vote.
Hi,

I am in trouble Sorting a field in crystal reports.

This is my output sorted data:

2012-C1-6
2012-C2-7
2012-C3-8
2012-C4-9
2012-C5-10
2012-C1-1
2012-C2-2
2012-C3-3
2012-C4-4
2012-C5-5


I sort this using Record Sort Expert and i set it by Ascending order in Crystal Reports

Is there another way to sort it like this:

2012-C1-1
2012-C2-2
2012-C3-3
2012-C4-4
2012-C5-5
2012-C1-6
2012-C2-7
2012-C3-8
2012-C4-9
2012-C5-10


I tried searching it on google but no luck finding near idea or answer in my problem.

Pls help. Thanks in advance.
Posted 25-Sep-12 10:30am
Updated 25-Sep-12 10:41am
v2
Comments
Savalia Manoj M 26-Sep-12 7:07am
   
What you want to sort? You want to sort only last digit??
chuan0308 26-Sep-12 21:31pm
   
Can you show us the code you used for sorting?

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Looks like you are sorting on the value of the last element of the data, and then the center element. Create a formula field and use that as a sort field.

HTH
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web01 | 2.8.170915.1 | Last Updated 2 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100