Crosstab problem

[shohan_db]

am using iReport 1.5.2

My table is as like

Date warehouse delivery No

7/7/2006 10 10-1

7/7/2006 20 20-1

7/7/2006 20 20-2

7/7/2006 30 30-1

8/7/2006 10 10-2

8/7/2006 10 10-3

11/7/2006 30 30-2

11/7/2006 20 20-3

 

I want Output will be as like

Date WH10 WH20 WH30 total delivery

7/7/2006 1 2 1 4

8/7/2006 2 0 0 2

11/7/2006 1 1 0 2

 

I can’t use crosstab in iReport

Pls send me the steps of crosstab……..by which I can create this report

what should I do????

Please help……

Thanks

Mainur rahman