Cross tab report issue(plz help it urgent)

[ooober]

 Hi..

     I have to made a crosstab report like this.

 

 _____________               6000                          __           60001                 ____

------------------------   Req   ------       Res            ----        Req --- Res         --------  

-------------------------   0$      ----- 0$-- 1 $ -- 2$   ----  0C$  -- 1C$ ---  1C$           --------          

 

        Test                    5                  10    0      3               2        1          3

        Test3                  5                  10    0      3               2        1          3

      Total                    10 $             20$   0$       6$         4C$    2C$   6C$

       Total Revenue    38 $      

 

   My problem is that  how to add  dynamic column for  each price in detail section of crosstab.

   Any suggention.

   Best Regards

   Hasham Habib