Monthly report in Total Issue, Return, Renewal & Payment.(Koha SQL Reports Queries)

 Monthly Report in Total Issue, Return, Renewal & Payment.

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

SELECT count(statistics.type) AS 'Total', statistics.type

FROM statistics

WHERE statistics.datetime >= concat(date_format(LAST_DAY(now() - interval 1 month),'%Y-%m-'),'01') AND statistics.datetime <= LAST_DAY(now() - interval 1 month)

GROUP BY statistics.type

ORDER BY statistics.type ASC

Run Report