>hi all,
>i need help
>
>

>mytable
>dno   typ  val val2
>1      1    10  30
>1     18    4   40
>1     49    100 70
>1      2    20  87
>1      3    90  34
>1      4    120 39
>2
>2
>
>

>
>i need result as
>

>dno   f1 val1 val2 f2 va2l  val22 f3 va3l   val32  f4 va4l   val42   f5 ..
> 1    1  10   30   18  4    40    49 100    70     2  20     87  ..........
> 2
>

>thanks

In your case you're looking for dynamic cross-tab. I suggest to take a look at FastXTab class in Downloads section here. It should work.