Sales Report Sorted By Discount Rate

I think this is an easy report but I am missing something.

We have a handfull of discount rates (items)at 100% that show how many free books leave our door based on things like faculty giveways, school give aways, etc.

I am trying to produce a simple Sales Report that sorts on the name of the discount rate and what transactions(items) used that discount Rate. The report would look something like:

Discount Rate Name
Tran Num| Date of Transaction|Item Name|Item Qty|Sales Price|Discnt|Rev


After trying to produce this report I see the problem where there are 2 items involved in the transaction, the Discount Rate (item) and the actual Sales item.