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
FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
WHERE items.homebranch =<> AND items.dateaccessioned BETWEEN << Between (yyyy-mm-dd)|date >> AND << and (yyyy-mm-dd)|date >>
ORDER BY LPAD(items.barcode,30,’ ‘) ASC

2) Total Circulation (Datewise)

SELECT
datetime AS “Date”,
cardnumber AS “Card number”,
surname AS “Last name”,
firstname AS “First name”,
CASE type
WHEN ‘issue’ THEN “Check out”
WHEN ‘localuse’ THEN “In house use”
WHEN ‘return’ THEN “Check in”
WHEN ‘renew’ THEN “Renew”
WHEN ‘writeoff’ THEN “Amnesty”
WHEN ‘payment’ THEN “Payment”
ELSE “Other” END
AS “Transaction”,
CASE value
WHEN ‘0’ THEN “-”
ELSE value END
AS “Amount”,
barcode AS “Barcode”,
biblio.title AS “Title”,
author AS “Author”
FROM statistics
JOIN borrowers ON statistics.borrowernumber=borrowers.borrowernumber
LEFT JOIN items ON statistics.itemnumber=items.itemnumber
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
WHERE DATE(statistics.datetime) BETWEEN << Date1|date >> AND << Date2|date >>

3) Title with number of copies

SELECT biblio.title AS Title, biblio.author AS Author,biblioitems.editionstatement AS Edition,count(items.itemnumber) AS Copies
FROM items
LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber)
GROUP BY biblio.biblionumber
ORDER BY biblio.biblionumber

4) Total Serial Received during the library wise and datewise

SELECT DISTINCT subscription.branchcode AS “librarycode”,biblio.title AS “Title”,serial.serialseq AS ‘Volume & Issue’,biblioitems.publishercode AS “Publisher”,serial.planneddate,serial.publisheddate
FROM serial
LEFT JOIN serialitems on (serial.serialid=serialitems.serialid)
LEFT JOIN subscription on (serial.subscriptionid=subscription.subscriptionid)
LEFT JOIN subscriptionhistory on (serial.subscriptionid=subscriptionhistory.subscriptionid)
LEFT JOIN subscriptionroutinglist on (serial.subscriptionid=subscriptionroutinglist.subscriptionid)
LEFT JOIN biblioitems on (biblioitems.biblionumber=serial.biblionumber)
LEFT JOIN biblio on (biblio.biblionumber=biblioitems.biblionumber)
LEFT JOIN aqbooksellers on (subscription.aqbooksellerid=aqbooksellers.id)
WHERE subscription.branchcode=<> AND serial.status=2 AND serial.planneddate BETWEEN <> AND <>

5) Total Serial claimed/missing /late librarywise and datewise

SELECT DISTINCT subscription.branchcode AS “librarycode”,biblio.title AS “Title”,serial.serialseq AS ‘Volume & Issue’,biblioitems.publishercode AS “Publisher”,serial.planneddate,serial.publisheddate
FROM serial
LEFT JOIN serialitems on (serial.serialid=serialitems.serialid)
LEFT JOIN subscription on (serial.subscriptionid=subscription.subscriptionid)
LEFT JOIN subscriptionhistory on (serial.subscriptionid=subscriptionhistory.subscriptionid)
LEFT JOIN subscriptionroutinglist on (serial.subscriptionid=subscriptionroutinglist.subscriptionid)
LEFT JOIN biblioitems on (biblioitems.biblionumber=serial.biblionumber)
LEFT JOIN biblio on (biblio.biblionumber=biblioitems.biblionumber)
LEFT JOIN aqbooksellers on (subscription.aqbooksellerid=aqbooksellers.id)
WHERE subscription.branchcode=<> AND serial.status BETWEEN ‘3’ AND ‘5’ AND serial.planneddate BETWEEN <> AND <>

For any query or support please write us at info@elibsol.com or whatsapp/telegram@9911556678.