Hi Barton, I’m using this report:
SELECT biblio.biblionumber,(select count(*) from reserves where biblionumber=biblio.biblionumber) as holdsonbib, items.barcode,items.itemcallnumber,biblio.title,items.issues,items.itemnotes,items.enumchron,items.onloan,items.notforloan,items.damaged,items.itemlost,items.withdrawn,items.datelastborrowed,items.datelastseen,items.dateaccessioned FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.ccode='XDVDBR' ORDER BY biblio.biblionumber I’m downloading the report as tab separated text, opening in Excel, conditional formatting the biblionumber column to highlight duplicate values in red, and filtering by cell color. Mike From: Barton Chittenden [mailto:[email protected]] Sent: Tuesday, December 20, 2016 8:45 AM To: Michael May <[email protected]> Cc: [email protected] Subject: Re: [Koha] Report for bibs with multiple items with item details On Mon, Dec 19, 2016 at 1:25 PM, Michael May <[email protected]<mailto:[email protected]>> wrote: I apologize. I've figured out how to add biblionumbers to a report of all items, and then how to identify and isolate duplicates in the downloaded spreadsheet. This pretty much does what I want. Thanks for listening. :) -Mike No need to apologize -- would you mind giving a more detailed description of what you did? Thanks! --Barton Click here<https://www.mailcontrol.com/sr/xBfa6Ks6MQ3GX2PQPOmvUubKwjUTrb0OnVqnnCxrXurEf54fsRkDBtg31lSFhtsBEGEwoHiksOqsCq9I+zBdpQ==> to report this email as spam. _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
