Jump to content
Changes to the Jaspersoft community edition download ×

JasperServer Report how to sort date


akar.johri

Recommended Posts

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

 

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...