How to Create Item Type wise Accession Register Report.

SELECT items.barcode AS Barcode,items.itemcallnumber AS 'Call Number',
CONCAT_WS('',biblio.author,'; ',ExtractValue
(metadata,'//datafield[@tag="700"]/subfield[@code="a"]')) AS Author,
CONCAT(biblio.title,' ',ExtractValue
(metadata,'//datafield[@tag="245"]/subfield[@code="b"]')) AS Title,
biblioitems.publishercode AS Publisher,biblioitems.Place,biblioitems.Pages,
biblioitems.Editionstatement AS Edition,biblio.Copyrightdate AS Year,items.Price,
biblio.unititle AS Subject,items.location AS Collection,
biblioitems.itemtype AS Department,items.itype AS 'Item Type',
biblioitems.url AS OnlineURL,items.Dateaccessioned As 'Date of Accessioned',
biblioitems.ISBN,biblio.notes,items.Issues,items.Renewals
FROM items
LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
LEFT JOIN biblio_metadata on (biblio_metadata.biblionumber=biblio.biblionumber)
WHERE items.homebranch =<<Branch|branches>> AND items.itype=<<Item type|itemtypes>> 
ORDER BY items.barcode ASC