Group Sorting
Posted: Wed Apr 20, 2011 3:21 pm
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:
Becomes something like the following when sorted on Month:
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.
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 31Code: 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