December 14, 2009 at 9:01 am
Hi
I am generating the reports using the cube as a source.
when i summerize the data in cube browser, the sorting order is normal like 1,2,3---
even while building the query of the report, i dont have any problem with sorting order
but, when i preview the report the order of the colums are changed to 1,10,11---,2,21,22--,3,31--- like that
can any one give the solution for this issue.
thank you
happy
December 14, 2009 at 10:32 am
This is occurring because of the way that numeric values are sorted. The query processor goes by the first character that it sees, and sorts that way. That's why you are seeing your data sorted as 1,11,12,13....2,20,21,22.
Is there any way that, for your lower numbers (1-9), you can append a 0 (zero) in front of them? If you are able to do that, then your sorting will work as you are expecting it to.
Cheers!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply