Thanks, Kchaudhry for the sample file. I am attaching the output for my efforts. I have tried 3 different versions of iReport .... 2.0.0, 3.7.0, and 3.7.1. Whenever I use pre-sorted data in the crosstab setup panel, I end up getting null values in the cells as shown. Here is my select statement - select *, case when row_name='Sample1' then 0 when row_name='Sample2' then 1 when row_name='Average' then 2 end as order_ from data_values order by order_ The select output gives me the output as in excel file (which is also enclosed). I am enclosing the output received for reference. I got the order needed for rows but the output contains unnecessary "null" values. Is there something I am not configuring??? Appreciate any pointers.