Missing Hold Report Update

All, after running it a week and talking with a couple libraries, I've made a couple changes to the missing holds report. You did not recieve one today. I think this report only needs to run once a week. We've noticed that it was capturing items before the system had a chance to move them on. So the report will run again on Monday and then every Monday after that. The second problem was I told it to pull all items with a copy of 1. This may have been an error I need to think more like the machine. (Don't worry my cranial cavity replacement is scheduled for a week from Thursday.) I should have told it to pull all holds with a copy less than 2. This way we can be certain that if it hits the report that title only has one item or copy attached to it. Now this does not account for duplicate of multiple records so the staff will still have to look at those and move the holds to a record with more available items. This also does not take into account patrons who have placed the hold on multiple records. Remember all holds placed in i-Bistro are title level holds. If a patron places three holds on the hardback, paperback and large print version of Beach House, he or she will recieve a copy from each hold. The result is some libraries have found that when they call the patron to tell them the hold has been cancelled the patron informs them that they have already had the book and returned it. Very few patrons tell the library when picking up the hold that they placed other ones and why should they they assume that the computer knows all. I'm looking into this some more but I do not see a way to prevent. Let me know how this new report works for you and if it is better than the other.