Click here to Skip to main content
11,707,470 members (77,901 online)
Rate this: bad
good
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
Edited 25-Sep-12 10:41am
v2
Comments
Savalia Manoj M at 26-Sep-12 7:07am
   
What you want to sort? You want to sort only last digit??
chuan0308 at 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
0 Maciej Los 240
1 Mika Wendelius 220
2 OriginalGriff 168
3 Sergey Alexandrovich Kryukov 145
4 Peter Leow 140
0 OriginalGriff 9,198
1 Sergey Alexandrovich Kryukov 8,562
2 CPallini 5,189
3 Maciej Los 4,921
4 Mika Wendelius 3,856


Advertise | Privacy | Mobile
Web03 | 2.8.150819.1 | Last Updated 2 Oct 2012
Copyright © CodeProject, 1999-2015
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