Cross Table Columns Sorting..

[nareshbangaram24]

Hi All,

A SQLQuery is returning the following results from DB.

CompanyName	Bucket
Steel	1day
Cement	2day
Infra	16-30 day
Cement	7-15 day
Steel	2day
Cement	7-15 day
Infra	1day
Cement	16-30 day
Infra	1day
Steel	16-30day

 

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
Steel	1	1	1	0
Cement	0	1	1	2
Infra	2	1	0	0

 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. 

Thank you.

[nareshbangaram24]

Could anybody please suggest me. 

[Friendly User]

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:

https://community.jaspersoft.com/questions/521463/how-sort-month-within-crosstab