How to sort the month in ascending order by month?

[cheapwebhoster]

Hi,

My Adhoc report is reported in month but when it sorted out either ascending or decending it uses the alphabetical order instead of the month sequence see below. My question is how to make it follow month sequence for example January, February, March, April etc....until December

[cheapwebhoster]

By the way i've found there is monthnumber field which can sort this out however it is in the form of numbers like 1,2,3,4,5..... how can i use this as the sorting order for the month name without putting it together into the table ....i am trying to create a measure in the ireport designer as below but no success

monthname("Day Date") order by MonthNumber("Day Date") <---------- the order by statement seems to be invalid any can tell me what is the statement for that?

 

[cheapwebhoster]

I have concatenate the MonthNumber and MonthName like so Concatenate("MonthNumber", '-', "MonthName"). This will do the trick as you can see below the month arrange correctly because the monthnumber is helping...but i dont want the month number to show. You can see 11-November, 12-December which is sucks

/sites/default/files/images/Concatenate.jpg

[cheapwebhoster]

Any idea please help!!

[pushpi.gangwar]

I am also facing the same problem. I have some data with months and years as columns. In mysql qeury i can see data is sorted

but when i see attach the same query and make set and then when i use this set in Ad hoc view i can see the order is chagned on charts/table/cross-tab

not sure why jasper is messing with sorting order. Although i can see i have selected option "Don't sort". Still facing issue.

[karlobuds]

I want to make similar 
i need to do by specific order
the chart only order by asc

 

 

[matthewgreger]

It's truly amazing there is not a simple solution to this. We use FileMaker internally and I can easily add a custom sort option that allows us to sort anything anyway we want. In this case, all I have to do is sort based on a pre-sorted list. And, sorting follows the order of the list.

Is there any decent work-around or solution for this issue? We use media months (first Monday of the month to last Sunday of the month) to define our months. So, we have to use custom calculated month fields. Sure would be nice to sort them!

[nareshkumar326]

Do let me know if this works:

CaseRange(MonthNumber("Date Start"), 1, Concatenate('           ', 'January'),
2, Concatenate('          ', 'February'),
3, Concatenate('         ', 'March'),
4, Concatenate('        ', 'April'),
5, Concatenate('       ', 'May'),
6, Concatenate('      ', 'June'),
7, Concatenate('     ', 'July'),
8, Concatenate('    ', 'August'),
9, Concatenate('   ', 'September'),
10, Concatenate('  ', 'October'),
11, Concatenate(' ', 'November'),
Concatenate('December'))

[nareshkumar326]

Do let me know if this works:

CaseRange(MonthNumber("Date Start"), 1, Concatenate('           ', 'January'),
2, Concatenate('          ', 'February'),
3, Concatenate('         ', 'March'),
4, Concatenate('        ', 'April'),
5, Concatenate('       ', 'May'),
6, Concatenate('      ', 'June'),
7, Concatenate('     ', 'July'),
8, Concatenate('    ', 'August'),
9, Concatenate('   ', 'September'),
10, Concatenate('  ', 'October'),
11, Concatenate(' ', 'November'),
Concatenate('December'))