I have a menu which contains certain items. I have to display the number of menus bought as well as the number of items bought.

e.g., I have menu Chinese with items Soup, Fried Rice and Chilli Chicken. These items can be chosen in any grouping. Suppose 20 orders of Soup Chilli Chicken were bought and 33 orders of Fried Rice chilli Chicken were bought. So the total Menu orders for Chinese to be displayed should be 20 33=53 whereas the individual item quantities will be Soup=20, Fried Rice=20 33=53 and Chilli Chicken=20 33=53. I have to display this in the order (grouped by menu)Chinese (53)->(grouped by items) Soup(20),Fried Rice(53),Chilli Chicken(53).

 When I am directly using the fields in the report, I am not getting the menu total correctly. My menu total is calculated on the basis of distinct ids of the menus bought and the items so displayed may show duplicate entries of those ids. I tried using subreports but that gives me the correct menu quantity but instead gives me multiple subreports for different ids. Can somebody help me?

aRcadehUnter