[Koha] On how to create a report

[Chitralekha Chitale]

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.2FBibliographic_Reports 

Mrs. Chitralekha Mahesh Chitale 
Librarian, LTCE, Navi Mumbai. 

----- Original Message -----

From: "catarinafrc [via Koha]" <ml-node+s1045719n5859353h45 at n5.nabble.com> 
To: "Chitralekha Chitale" <library.ltce at 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 at 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-tp5859353p5859364.html
Sent from the Koha-general mailing list archive at Nabble.com.