Here is the most basic version of the report you are looking for: SELECT biblionumber FROM items WHERE itype=<<Select itemtype|itemtypes>> When you run the report, you will be asked to select the itemtype to report on. Kyle http://www.kylehall.info ByWater Solutions ( http://bywatersolutions.com ) Meadville Public Library ( http://www.meadvillelibrary.org ) Crawford County Federated Library System ( http://www.ccfls.org ) Mill Run Technology Solutions ( http://millruntech.com ) On Fri, Oct 30, 2015 at 5:54 AM, Charlotte Stock <charlotte@bu-london.co.uk> wrote:

I've searched the forum but cannot find an SQL report that will allow me to generate a list of biblio numbers for a specific item type (for example, list all DVDs or list all Set Texts). Should I be creating a report for this type of listing or should I be using another tool to create the information I need?

Thanks in advance for your time Charlotte

-- View this message in context: http://koha.1045719.n5.nabble.com/Create-a-report-that-lists-biblio-number-f... Sent from the Koha-general mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha