SortOrder and Heading Click have different results
Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=21851
Printed Date: 23 November 2024 at 7:12am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: SortOrder and Heading Click have different results
Posted By: bellmik
Subject: SortOrder and Heading Click have different results
Date Posted: 15 August 2013 at 11:03am
I have data in a report control that looks like the following:
Ghi
Def
Abc
gzz
dzz
azz
I click on heading to sort I get:
Abc
azz
Def
dzz
Ghi
gzz
But if I use SortOrder.Add to sort I get
Abc
Def
Ghi
azz
dzz
gzz
where the Upper case characters are sorted before the lower case letters.
I am using 15.1.3. Are you aware of this problem and if so, has it been fixed in a later version?
Is there a workaround in 15.1.3?
Thanks
|
Replies:
Posted By: bellmik
Date Posted: 15 August 2013 at 11:04am
I should add that my desired result is that the SortOrder sort in the same manner as the heading click.
|
Posted By: bellmik
Date Posted: 15 August 2013 at 2:23pm
Just a little more information.
I have tried using RC1.Records.CaseSensitive = False but this does not seem to have any effect.
I have also tried
Item = Record.AddItem(sItem)
Item.SortPriority = Val(ConvertTextToAsciiDigits(sItem.ToUpper()))
where
ConvertTextToAsciiDigits is a function I wrote to made a string of ascii characters from the text I wanted sorted, but the resultant string is too long to be converted into an integer.
Any other ideas for me?
|
Posted By: Willowmaster
Date Posted: 17 October 2013 at 7:24am
Add the value as ToUpper and set the caption to the original value. I believe it sorts on the value. But as I read the Online Help the CaseSensitive option should work too.
-------------
Product: Xtreme SuitePro (ActiveX) version 15.3.1
Platform: Windows XP (32bit) - SP 3 (on VMWare)
Language: Visual Basic 6.0
|
Posted By: olebed
Date Posted: 24 September 2014 at 3:34pm
Hi bellmik,
What do you mean by SortOrder ? RepotControl.Columns.SortOrder
used only for columns, and SortOrder.Add() added only columns.
Can you please provide a small sample application so that we could debug this issue?
Thank you.
Regards,
Oleksandr Lebed
|
|