Common Resource and Task Fields

I guess that this separate fields in both task and resource modes is the cause of the problem.



I can get partial success in either mode by using either the Resource Usage view and grouping by resource group(but this will not allow me to further group by the two work packages that are involved), or by using a task view and grouping by the Work Package ID from the Text field (but where multiple resources are allocated against a task, the grouping will not show a task twice under the respective resource group where two resources are used - it tends to show single resources then "combination" resources).



I suspect that the above makes my situation as clear as mud, but it is the best way of describing the situation that I can think of.



As a final resort, I may be forced to copy the data into Excel and manipulate in there!!

Apologies - working in MSP2000.