prissilaaroul

I wanted to know if the foll. structure is possible using crosstab or is there any other utility available to obtain this o/p ? TYPE 1 TYPE 2 V11 V12 V13 V14 V15 TYPE_VAL1 TYPE_VAL2 TYPE2_VAL1 TYPE2_VAL2 Thanks in advance,

Thanks Rajendra. The link was really helpfull. And its a great work, explained clearly. Is it possible to display more informations using crosstab: Type1 Type2 Type3 V11 V12 V13 V14 V15 1 3 6 V21 V22 V23 V24 V25 5 4 10 .. Crosstab allows to display a max of 2 rows and 2 columns only. Thanks in advance.

Hi, I would like to know if there is any utility in iReport to convert rows to columns. Similar to pivot function in oracle. Thanks in advance. Code:Example :Output actuel :Type1 1Type2 3Type3 6Output expected : Type1 Type2 Type3 1 3 6