http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=1824 ------- Comment #4 from drdrulm@yahoo.com 2008-03-21 10:10 ------- I am rewriting this. The patrons are irrelevant since they will come up on check in correctly. The patrons *are* important for waitingreserves.pl but there is a 1-1 relationship patron to item. This is not an easy one, however, if it is really to be done correctly, there can be multiple database queries and item information filtered as needed. I have a good report that is doing what it is supposed to be doing -yes in Perl (same as any other imperative language, some different syntax, no big!) ;) The main point of the report is to provide a list of 1. How many books to pull 2. Show available books AND LOCATIONS note: without (holding-library/location/itype/and call) the book is not going to be easy to find. Example: title:"Trucks," with call 623.324. So it is Non Fic, but is it a book, video, what? I created a report in the last hour and called it "newpendingreserves.pl/tmpl" It filters out the: Waiting - (why would a librarian need to pull it if waiting?, makes counting number to pull more difficult! Uses Distinct - Keeps out the dups Groups By Reserves.biblionumber (I had barcode in there before-whoops!-T-Y-P-O!) Only select if not damaged, lost, wthdrawn, or not for loan. Also make sure the item is not in a Truck (branch Transfers) It is working well for my setup at Stow. Goede dag Submitting shortly. Goede dag! :] ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.