Circulation Daily Transaction Counts.
- Crete the New SQL Report
- Copy and Paste following lines in the SQL report. Save and close.
SELECT type AS 'Transaction Type', Count(datetime) AS Count FROM statistics
WHERE date(datetime) BETWEEN << FROM |date>> AND <<TO |date>>
GROUP BY type
ORDER BY type ASC
Run Report