reservation lottery report

We have instituted the Reservation Lottery at our club.  There is a little bit of grumbling about it - but could be those who always grumble.  It would be great to be able to run a report to know how many people are NOT getting the reservations they want.  There is no way to really know if this system is helping us - or just making people unhappy.