SortOrder and Heading Click have different results |
Post Reply |
Author | |
bellmik
Groupie Joined: 03 August 2011 Status: Offline Points: 14 |
Post Options
Thanks(0)
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 |
|
bellmik
Groupie Joined: 03 August 2011 Status: Offline Points: 14 |
Post Options
Thanks(0)
|
I should add that my desired result is that the SortOrder sort in the same manner as the heading click.
|
|
bellmik
Groupie Joined: 03 August 2011 Status: Offline Points: 14 |
Post Options
Thanks(0)
|
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? |
|
Willowmaster
Senior Member Joined: 12 July 2010 Location: Netherlands Status: Offline Points: 180 |
Post Options
Thanks(0)
|
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 |
|
olebed
Admin Group Joined: 01 July 2014 Location: Ukraine Status: Offline Points: 841 |
Post Options
Thanks(0)
|
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 |
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions 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 |