report sort query

Hello everybody,

I am writing a small recipe database. In order to create a correct
ingredients list (the largest ingredient placed first and the
ingredients summed up (sorted) where needed), I would need a bit of
help.

Basically starting from the following small table:

% Group Detail
1% Fruit Apple
2% Fruit Pear
5% Cabbage
10% Steak

This should show on the report as follows

Steak, Cabbage, Fruit: (Pear,Apple)

Help would be greatly appreciated.