AnsweredAssumed Answered

Repeat question: Show months in order on Ad hoc report (Jaspersoft)

Question asked by vtleogal2 on Dec 1, 2016
Latest reply on Dec 5, 2016 by vtleogal2

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?