Please provide the current report along with what the report should look like,

But it sounds me that you need to add some grouping, but cannot be sure without seeing what you have now and what you want it to actually look like.