Incorrect Totals due to database relationship

[IceRuby]

Hi there
I am using Crystal Reports Version 9.0.
My report in the majority has a one to many relationship however in rare instances the table which typically has the many relationships only has the one and the table normally only holding one has many. Any ideas of solving this issue would be great (!!) but first problem firs, the some totals are correct and some are incorrect.
e.g
Group #1 - Work Order no.
Group #2 - Resource No.
Total Allocated Hrs Total Hrs worked
#38 12.00 5.00
#52 19.00 26.00

I tried using a running total to sum hours, evaluate on change of resource no. and reset on change on group but am still getting incorrect values. (even worse than if I just use summary values) Main issue is duplicates where more than records on on side than the other.

Thanks for your help in advance.

 

[lbass]

Please provide a sample of detail level data so we can see how the running totals need to be set up.

-LB