Environment is Jaspersoft Studio Community Edition version 6.9.0
User has a crosstab report. The row values are integers from 1 to 12, but they are stored as Strings in the database. The issue is that, in String sort order, the rows are sorting as "1 10 11 2 3 4". They'd like them to sort in integer sort order: "1 2 3 ... 9 10 11 12".
I'm trying to figure out how to make this happen. I think it's possible, but I can't find any documentation about crosstabs that goes this deep into the detail.
I think the right answer will have something to do with the bucket grouping for the row group, but nothing I've tried so far has done the trick.
Can anyone post an example of how to do this?