Sort Order CR,Vb.Net 2010
Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17624
Printed Date: 06 Apr 2025 at 5:08am
Topic: Sort Order CR,Vb.Net 2010
Posted By: TinTin19
Subject: Sort Order CR,Vb.Net 2010
Date Posted: 25 Sep 2012 at 5:26pm
Hi,
I'm new in this forum. 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.
|
Replies:
Posted By: lockwelle
Date Posted: 27 Sep 2012 at 5:03am
|
what I would try is to create a formula that returns the sort order that you want, then sort / group by the formula.
|
|