A SQLQuery is returning the following results from DB.
I have defined cross table as below :
* Company name as row group.
* Bucket as column group with Ascending order.
* Bucket as Measure.
Now the resultant cross table is displaying as below :
|Company||1day||16-30 day||2day||7-15 day|
If you observe colums are not displying in ascending order. It is taking ascending order as 1day, 16-30day, 2day, 7-15day.
But It should be like 1day, 2day, 7-15day, 16-30day.
How can i achive this. Please suggest me.
Crosstabs sort the values alphabetically when the value is alphanumerical. You will either need to assign these buckets some numeric values instead and then If-Then them back to text values or create a custom comparator. Here is a similar problem with Month sorting: