I am working on a purchase request form. Through this form all company departments make requests of the products they need to the purchase department. Currently the report shows a row per product, in each row there is a quantity field. So for example, if 3 departments ask for 2 apples I will have in the report 3 rows of 2 apples each (it is ok,I need a report that looks like this too). I would like to have an other report that shows  the total amount requested for each product, so instead of  3 rows of 2 apples I would like  to have 1 row of 6 apples.

How can I do this? should I make the report based on the purchase request  form or based on the product inventory?

Any help will be appreciated.