Omorak_Taybeh

how can i make a static column/row in crosstab. For example below, can I have a fixed jan, feb, march, ... column instead of it generating dynamically? location jan feb mar apr may jun jul aug sep oct nov dec london 500 62 200 50 100 60 100 46 89 200 150 210 paris 50 26 20 500 50 70 40 200 70 40 250 50 I want the column (jan, feb, mar,apr,....) to always show up regardless of their measures zero or have values. Like they are fixed.

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.

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

!

thank you Tarun, I will follow your steps one by one. but one question please! can't i add the measures fields as a static? i mean ( revenue, quantity and margin) to be a static, since the query will give the sum and count as numbers. how i can add the name of column in crosstab? i hope you understand what i mean. thank you again

Hi, I want to create this type of a report using cross tab. i am a fresh on ireport the below is a picture of my report view which I want to create. This is monthly summary report. Please help me as i am a fresher and this is the first time i use it . Thank you.