I have Product form with Product Name, SKU and Unit.

I have Stock form with Product, Warehouse, Stock.The stock form will have stock for each warehouse like this.

Product Warehouse Stock

A          W1             10

A          W2             20

B          W1               1

B          W2             10

I need to generate a consolidated stock report showing the sum of all stocks for each product.

Product Name                Sku                 Stock      Unit

A                                   AX1                    20        Nos.

B                                   BX1                    11        Nos.

How can I do this?