Crystal Reports Sorting Control Not work correctly

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: Sorting Control Not work correctly

Author	Message
Hossam Newbie Joined: 31 Mar 2009 Location: Egypt Online Status: Offline Posts: 23	Topic: Sorting Control Not work correctly 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
	IP Logged

JohnT Groupie Joined: 20 Jan 2008 Online Status: Offline Posts: 92	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..... Edited by JohnT - 03 Apr 2009 at 8:53am
	IP Logged

Hossam Newbie Joined: 31 Mar 2009 Location: Egypt Online Status: Offline Posts: 23	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 thanks,regards
	IP Logged

JohnT Groupie Joined: 20 Jan 2008 Online Status: Offline Posts: 92	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.
	IP Logged

Hossam Newbie Joined: 31 Mar 2009 Location: Egypt Online Status: Offline Posts: 23	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)
	IP Logged

JohnT Groupie Joined: 20 Jan 2008 Online Status: Offline Posts: 92	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.
	IP Logged

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.047 seconds.