Dear Colleague, Thanks a lot for this help. Blessings, Yesan Sellan, B.Com., MLISc., PGDLAN, UGC-NET., BCS Chief Librarian South Asia Institute of Advanced Christian Studies (SAIACS) 363 Dodda Gubbi Cross Road, Kothanur P.O., Bangalore 77, India Phone: 91 80 2846 5235/5344/ 5649, Fax: 91 80 28465412, Mobile: 91-9972348251 Website: www.saiacs.org Alternative Email: yesans@gmail.com or yesan.sellan@saiacs.org ______________________________________ IMPORTANT : This message is intended only for the addressee. It may contain confidential information. Any unauthorized disclosure is strictly prohibited. If you have received this message in error, please notify us immediately so that we may correct our internal records. Please then delete the original message. Thank you. Please consider the environment before printing this email. -----Original Message----- From: lis-forum-bounces@ncsi.iisc.ernet.in [mailto:lis-forum-bounces@ncsi.iisc.ernet.in] On Behalf Of Indranil Das Gupta Sent: 08 August, 2016 1:40 PM To: lis-forum@ncsi.iisc.ernet.in Subject: [LIS-Forum] Generating a SQL report of subject wise list of titles with no of copies in Koha. Dear all, Last week one of our readers, a college librarian from West Bengal with a forthcoming NAAC visit, wrote in to us with the request for a custom SQL report in Koha Integrated Library System that can generate subject wise title list with details of author, number of copies, the subject, biblionumber along with sequential numbering of the rows of the report. The following blog post describes a method of getting that to work. Further there is link to an online hosted Koha instance where anyone can try out the SQL report using the username and password provided in this blogpost. http://blog.l2c2.co.in/index.php/2016/08/08/a-custom-subject-wise-report-of-... With regards, -idg -- Indranil Das Gupta L2C2 Technologies Phone : +91-98300-20971 Blog : http://blog.l2c2.co.in IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ LIS-Forum mailing list LIS-Forum@ncsi.iisc.ernet.in http://ncsi.iisc.ernet.in/mailman/listinfo/lis-forum --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus