Hello Paste the following program in reports. SELECT CONCAT('<a href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',items.biblionumber,'\">',biblio.title,'</a>') AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <<Accessioned BETWEEN (yyyy-mm-dd)>> AND <<and (yyyy-mm-dd)>> I hope this will give the results you expect. For more reports visit http://wiki.koha-community.org/wiki/SQL_Reports_Library#Catalog.2FBibliograp... Mrs. Chitralekha Mahesh Chitale Librarian, LTCE, Navi Mumbai. ----- Original Message ----- From: "catarinafrc [via Koha]" <ml-node+s1045719n5859353h45@n5.nabble.com> To: "Chitralekha Chitale" <library.ltce@ltjss.net> Sent: Friday, October 30, 2015 1:44:43 PM Subject: On how to create a report Hey guys, My question is how can I create a report to know how many books were cataloged from Jan till now (or any other time period)? I have tried, but I find that the manual is not clear enough on this. all the reports I created were not able to give me this info.... Thanks [I still have 3.10 version, and NO I can't changed it now, so any help will be much appreciated] Thank you, If you reply to this email, your message will be added to the discussion below: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353.html To start a new topic under Koha-general, email ml-node+s1045719n3047918h60@n5.nabble.com To unsubscribe from Koha-general, click here . NAML -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p585936... Sent from the Koha-general mailing list archive at Nabble.com.