I don't mess with the reports, so I can't help with them. For this I would run a few SQL commands. I'll write some here for you. SELECT COUNT(barcode) FROM items WHERE barcode <> '' AND barcode IS NOT NULL SELECT categorycode,COUNT(barcode) FROM items WHERE barcode<> '' AND barcode IS NOT NULL GROUP BY categorycode; SELECT COUNT(biblionumber) FROM biblio These will give you the total number of barcodes, the number of barcodes per item category, and the total number of titles in the database. Good luck. On Tue, 2009-10-06 at 00:59 +0600, Zico wrote:
Hi, If i want to see total number of inserted books,cds,dvds, journals and others which are inserted into my Koha 3.0 server, what i need to do? I went to:
Reports --> Statistics Wizards --> Catalog
But, nothing is showing but only 0. But, my inserted items are 5,000 approximately. i want to know the exact figure.
-- Best, Zico _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel -- Michael Hafen Systems Analyst and Programmer Washington County School District Utah, USA
for Koha checkout http://development.washk12.org/gitweb/ or git://development.washk12.org/koha