Hi Dixson, take a look at the Koha Reports library, especially the Query MARC section: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC So for your report, you could do: select   dateaccessioned,   (select description from itemtypes it where i.itype = itemtype) as itemtype,   barcode,   author,   title,   ExtractValue(metadata, '//datafield[@tag="245"]/subfield[@code="n"]') as Medium from items i left join biblio b on (i.biblionumber = b.biblionumber) left join biblio_metadata bm on (i.biblionumber = bm.biblionumber) order by 6, 5 Hope this helps, Katrin On 09.04.19 13:02, Dixson Rodriges wrote:

Please help me, how to generate a report on Language wise tiles of the items.

The report should contain the the follwoing Fields

Item type|Bar code|Author  | Title | Language of the tile which we are mentioning in the "245 h" in the Catalogue

DateaccessioneditypeitemcallnumberbarcodeauthortitleCopyright Medium Regards, Dixson _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha