Month wise Circulation Report for a Specific Year (Koha SQL Reports Queries)

 Month wise Circulation Report for a Specific Year.

• Crete the New SQL Report
• Copy and Paste  following lines in the SQL report. Save and close.

SELECT

      monthname(datetime) AS Month,

      SUM( IF(type = 'issue', 1, 0 )) AS Issues,

      SUM( IF(type = 'renew', 1, 0 )) AS Renewals,

      SUM( IF(type = 'return', 1, 0 )) AS Returns,

      COUNT(statistics.type) AS 'Total Transactions'

FROM  statistics

WHERE YEAR(datetime) = <<Enter Year YYYY>>

GROUP BY month

ORDER BY month(datetime) ASC

Run Report