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]" <[email protected]>
To: "Chitralekha Chitale" <[email protected]>
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
[email protected]
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.
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
https://lists.katipo.co.nz/mailman/listinfo/koha
