How to prepare the report on the number of titles in koha.

     This article shows how to prepare the report on the Number of Titles in koha.

Go to: Koha Home/ Reports / Create from SQL

Copy and paste the below SQL source code.

SELECT 

ROW_NUMBER() OVER (ORDER BY DATE(title), CONCAT(title, " ", author)) As 'Sl.No',  Title, Author,  GROUP_CONCAT(biblionumber SEPARATOR ', ') AS Biblionumbers

FROM biblio 
GROUP BY CONCAT(title) 
HAVING COUNT(CONCAT(title,"/",author))>0

Save.

Run Report.

Reference: https://wiki.koha-community.org/wiki/SQL_Reports_Library