Dear Friends, I would like to prepare a report from "marcxml" field in "biblioitems" table. The report should include author, title, subject and abstract. I got some hint from koha wiki page, http://wiki.koha-community.org/wiki/SQL_Reports_Library#Query_MARC But I failed to wrote an SQL query for the purpose. I am not familiar with writing query to extract data from XML part in MySQL. Can you help me to prepare a report from "marcxml" ? If anybody from developers or users give guideline with examples, that will be a good contribution to Koha community. -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White