Print Page | Close Window

Sorting Control Not work correctly

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5991
Printed Date: 19 May 2024 at 1:38pm


Topic: Sorting Control Not work correctly
Posted By: Hossam
Subject: Sorting Control Not work correctly
Date Posted: 03 Apr 2009 at 6:44am

Hi all,

I using sorting control on all report columns but when i try to sort Ascending or descending

The result not correct do I missed something

Thanks , regards

  


Replies:
Posted By: JohnT
Date Posted: 03 Apr 2009 at 8:52am
Can you give some more information ?  How many columns do you have that you are sorting ?  Can a column have more than 1 record where the value in that column is the same ? 
 
Remember, when doing multiple sorts, the first sort occurs.  The second sort will only sort those records where the value for the first sort occurs multiple times.  The third sort will sort only records where the second sort value occurs multiple times etc.....

Posted By: Hossam
Date Posted: 03 Apr 2009 at 11:45am

Could you please check below URL i uploaded my report screen shoot and describe the problem

 
http://cid-a7ad7b8010a177df.skydrive.live.com/browse.aspx/Public?uc=1&isFromRichUpload=1 - http://cid-a7ad7b8010a177df.skydrive.live.com/browse.aspx/Public?uc=1&isFromRichUpload=1
 
 
thanks,regards

Posted By: JohnT
Date Posted: 03 Apr 2009 at 12:41pm
Sorry !  When I go to the link, I see two images that don't look like a Crystal Report and I don't see any description of your problem.

Posted By: Hossam
Date Posted: 04 Apr 2009 at 12:59am

Dear,

Kindly find below brif description about current situation

 

 my report include 10 columns

i should add sort control on all columns

my problem is my first column is "ID" when press sort Ascending the value display as following

 

IM10016

IM10044

IM10082

IM10077

---it should be like following

IM10016

IM10044

IM10077

IM10082

-----------

 when press sort descending the column be as following

 

IM10077

IM10082

IM10016

IM10044

---it should be as following

IM10082

IM10077

IM10044

IM10016

-------------------

 

Report column type and len.

Description (140)

Name(140)

CATEGORY(50)

Open Time(datetime)

Contact Name(140)

Name(140)

Opertaor(90)

 

 

 

Posted By: JohnT
Date Posted: 06 Apr 2009 at 2:40pm

When you go to Report, Record Sort Expert and look at the right side, (sort fields) does it show your ID as the only item listed or at least show the ID as the first item listed ?  If so, it should sort them correctly. 

You say ID is the first column but does that mean it is the first column on the report or the first column in your sort ?  What is the length of the ID field ? 

Sorting on a field is a pretty straightforward process so this is a bit of a mystery.


Print Page | Close Window