I'd really have to see your report to help you with this one. It may take writing a sql command to only display the details you want, and then a formula to do the calculations.

Depending on your programming skills, you may be able to do it with formulas. Sometimes I write three formulas using a shared numbervar. You put one in the group header, one in the detail, and one in the group footer. The one on the group header initializes, or resets, the value. The on in the footer displays the value. The one in the detail sections sets, or sums, or calculates the value on some condition.

If you want me to take a look, send me a copy of the report in a private message.

Cheers