![](https://secure.gravatar.com/avatar/01b6f602432ff215ca5ddf49c125f25d.jpg?s=120&d=mm&r=g)
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.