I saw one or two older posts on this, but no firm answers were provided.
In Jaspersoft Ad hoc:
Crosstab report;: Example: rows = resources and then the columns are by month, allocation (similar to resource portlets in Clarity under Resource planning)
The months (using calendar Month ) show in alpha order and not calendar order. Since this is a big flaw in Jaspersoft Ad hoc, I read through Jaspersoft that you can try to do a concatenate, but how does that work in Clarity?
I tried to concatenate the Month Number (using Calendar Month Start date attribute) + month Name ( using Calendar Month attribute) but no matter what I do, it says invalid expression, so I must be doing something wrong.
so in using calendar months (not fiscal), how do we put the months in a calendar order Jan -Dec on a crosstab ad hoc report?