Sort on Month name in crosstab report

[Omorak_Taybeh]

Hi all

I have a crosstab report which displays months as rows. When i run the report the rows start with aug and go on in ascending order. How can i sort this report based on our calender like jan, feb,march .....
Thanks

[zh3ntil]

you should add month number like '01-Jan'. So jasper will order as you want. Or, there is a field like MONTH_NUMBER in your query result, you can use month_number as sort field.

[Omorak_Taybeh]

thank you for your reply.

what i do is edit the query to be (TO_CHAR(REQUEST_TIMESTAMP, 'MM') "REQUESTDATE") to return the date just like 01,02,03,.... then i put in the expression for requestdate header

(
    $V{REQUESTDATE}.intern() == "01" ? "Jan" :
    $V{REQUESTDATE}.intern() == "02" ? "Feb" :
    $V{REQUESTDATE}.intern() == "03" ? "Mar" :
    $V{REQUESTDATE}.intern() == "04" ? "Apr" :
    $V{REQUESTDATE}.intern() == "05" ? "May" :
    $V{REQUESTDATE}.intern() == "06" ? "Jun" :
    $V{REQUESTDATE}.intern() == "07" ? "Jul" :
    $V{REQUESTDATE}.intern() == "08" ? "Aug" :
    $V{REQUESTDATE}.intern() == "09" ? "Sep" :
    $V{REQUESTDATE}.intern() == "10" ? "Oct" :
    $V{REQUESTDATE}.intern() == "11" ? "Nov" : "Dec" )

and now the report is sorted.