Clay,

I tried this with AdventrueWorks and managed to get something sorted ...

Create 2 reports, a master and a detail.

Master report:

SELECT ContactId FROM Person.Contacts WHERE (whatever ...)

Add a table to the...

How about trying this approach:

SELECT TOP 15

   PlayerID as RecordID,

   PlayerName as RecordLabel,

   ot.BuyerTeamID as RecordExtraID,

   ot.BuyerTeamName as RecordExtraLabel,

   Bid as RecordValue,

   'HighestTransfer' as Type,

   0

FROM

 OldTransfers...