advance crosstab

[shohan_db]

My table format is given below

 

Table1

 

Product ID Unit Price

1001 10

1002 1

1003 100

 

 

Table2

 

Product ID Warehouse Quantity

1001 Wh10 10

1002 Wh10 1

1003 Wh10 4

1001 Wh20 2

1002 Wh20 100

1003 Wh20 10

1001 Wh30 30

1002 Wh30 2

1003 Wh30 5

 

 

I want to create a report like

 

Product ID Wh10 Wh20 Wh30 Total

Quantity Amount Quantity Amount Quantity Amount Quantity Amount

 

1001 10 100 2 20 30 300 42 420

1002 1 1 100 100 2 2 103 103

1003 4 400 10 1000 5 500 19 1900

 

 

 

I have create a crosstab report in iReport 1.2.6 ,

I have select product ID as row group.

But I don’t know which field I use as column group and details field.

 

Please tell me the solution

 

Thanks

Shohan