I have a requiremnt where we have to sort a column which has both numbers and alphanumeric values. Columns values are 1,2,3,4,5,8,8A,8B,9,9A,9B,10,10A,10B,11A,11B1,11B2,12,28,n\a,DC7A,DC7B,DC8A,DC8B,DC9A,DC9B,DC14A,DC14B,DC16A,DC16B,DC16E,DC16F etc
What i want as sorting is stated below::
1
2
3
4
5
8
8A
8B
9
9A
9B
10
10A
10B
11A
11B1
11B2
12
28
n\a
DC7A
DC7B
DC8A
DC8B
DC9A
DC9B
DC14A
DC14B
DC16A
DC16B
DC16E
DC16F
I don’t want to use custom sort as there might be more values coming into this column in future. May be numeric or may be alpha-numeric. I am using the BO 6.5 version.
I found a workaround for this issue. What i did is removed all the filters from the report re-ran the report. This ensured all the values of that particular column flows into the report. I then applied a custom sort according to my requirement, saved the report,re-applied the filters and ran the report again. And there it was, the sorting came as expected. I know it was a heck of a job to do this. But I had to make this happen asap. Could not find a better solution.
But one issue we have here is, if suppose in future we have more values coming into that column, they will appear just below the custom sort, irrespective of the value it holds.
Hello aderasmo,
If all your values start with IFC then u can create a variable to use the substring command to just pick up the numeric values and then use that variable in the report as a column, hide it and there u have the sorting.
