Group Sorting

[Oaktree]

I noticed that the report's group sorting logic attempts to sort information even if it is already sorted. In other words, it shuffles the data.

This is problematic in some cases where column values are horizontally ordered as well, such as a calendar report.

For example:

Code: Select all

Month      WeekDay1     WeekDay2            WeekDay3       WeekDay4        WeekDay5       WeekDay6          WeekDay7
January                                                                                                        1
January       2             3                  4               5               6              7                8
January       9             10                 11              12             13             14               15
January       16            17                 18              19             20             21               22
January       23            24                 25              26             27             28               29
January       30            31

Becomes something like the following when sorted on Month:

Code: Select all

Month      WeekDay1     WeekDay2            WeekDay3       WeekDay4        WeekDay5       WeekDay6          WeekDay7
January                                                                                                        1
January       2             3                  4               5               6              7                8
January       23            24                 25              26             27             28               29
January       16            17                 18              19             20             21               22
January       9             10                 11              12             13             14               15
January       30            31

It was a simple step for me to remove sorting on the group; however, it took me a little while to realize that the report's logic was the culprit.

[Alex K.]

Hello,

Please send us your report with sample data for analysis.

Thank you.

[Oaktree]

Sent.

[Andrew]

Thank you.