How to Create Collection wise and Department wise Books in koha

1.Add collections to Authorized Values

Go to Koha > Administration > Authorized Values and select CCODE

Select New authorized value for CCODE button

Add a new Collection Code (For Example English, Tamil, General,etc)

2.Add Department to Authorized Values

Go to Koha > Administration > Authorized Values and select LOC

Select New authorized value for LOC button

Add a new Department Code (For Example CSE, IT, EEE, ECE, CIVIL, MECH, etc)

Add collection or Department to record

Create a catalogue record, Koha > Cataloguing

Add Biblio information (e.g. author, title, publisher, ISBN, etc.)

Save the Biblio information of the catalogue.

The collection code and department code (c - Shelving location) appears in the Item Information part of the catalogue

Generate collection and department wise report

Reports > Create from SQL

Copy and Paste following lines in the SQL report. Save and close.

SELECT location AS 'Department',COUNT(barcode) AS Count FROM items WHERE barcode <> ''

  AND barcode IS NOT NULL GROUP BY ccode

How to create a SQL report : https://youtu.be/scuXS7wVFdM
Run Report