Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Report Control
  New Posts New Posts RSS Feed - SortOrder and Heading Click have different results
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

SortOrder and Heading Click have different results

 Post Reply Post Reply
Author
Message
bellmik View Drop Down
Groupie
Groupie


Joined: 03 August 2011
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote bellmik Quote  Post ReplyReply Direct Link To This Post Topic: SortOrder and Heading Click have different results
    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

Back to Top
bellmik View Drop Down
Groupie
Groupie


Joined: 03 August 2011
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote bellmik Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
bellmik View Drop Down
Groupie
Groupie


Joined: 03 August 2011
Status: Offline
Points: 14
Post Options Post Options   Thanks (0) Thanks(0)   Quote bellmik Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
Willowmaster View Drop Down
Senior Member
Senior Member
Avatar

Joined: 12 July 2010
Location: Netherlands
Status: Offline
Points: 180
Post Options Post Options   Thanks (0) Thanks(0)   Quote Willowmaster Quote  Post ReplyReply Direct Link To This Post 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



Back to Top
olebed View Drop Down
Admin Group
Admin Group


Joined: 01 July 2014
Location: Ukraine
Status: Offline
Points: 841
Post Options Post Options   Thanks (0) Thanks(0)   Quote olebed Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.