You need to copy the SQL code & go to your Koha report module then click on 'Create from SQL' and paste the copied sql code in the box. After giving report just save and run it. 1) Accession Register (Datewise & Librarywise) SELECT items.Dateaccessioned AS 'Accession Date',items.Barcode,biblio.Author,biblio.Title, biblioitems.Publishercode AS 'Publisher',biblio.Copyrightdate AS 'Year', biblioitems.Pages,items.ItemCallnumber AS 'Call No.',biblioitems.ISBN,items.booksellerid AS 'Vendor' ,items.Price,items.ccode [...]