Sort Order Crystal Reports

See more:

VB

CrystalReports

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.