JasperServer Report how to sort date

[akar.johri]

Hi all,

 

I had 3 different tables with date as "dd-mm-yyyy" format in my chart I want to show as "Jan-2018" .

So I wrote a case statement to get 1=Jan and so on to 12 = Dec.
Now I concatenated with a '-' and 'year'

In chart I want to order it by date but as after applying case and concatenating it became string .so it's ordering alphabetically.But I need to sort my chart as date.

Can anyone help me on same

 

 

[reportdev]

try sorting your data either using Sort Fields or Order by date itself (not the concatenated format)

Check this thread: https://community.jaspersoft.com/questions/1106286/convert-month-name-month-number